John Clark
John.Clark at niagaracounty.com
Mon Oct 27 15:06:56 CST 2003
I suggested this, but she doesn't get it...and I don't have time to do it right now. So, if I can just give her a quick answer for now, and then dodge her for a few days, I'll be good to go. However, my headache has started to ease, and with it I have gained some clarity. I am realizing how stupid my approach was--even if I could find the proper syntax to reference the table, it still won't work. I think I'll just have to be mean and tell her she is doing it wrong, and that I can help her re-work it, but she will have to wait a few days. >>> wdhindman at bellsouth.net 10/27/03 03:33PM >>> ...why not change the form source to a query based on both tables? William Hindman <http://www.freestateproject.org> - Do you want liberty in your lifetime? ----- Original Message ----- From: "John Clark" <John.Clark at niagaracounty.com> To: <accessd at databaseadvisors.com> Sent: Monday, October 27, 2003 3:19 PM Subject: [AccessD] Dumb one for ya! > I am trying to help someone with their DB...I don't even know why they > are doing one, because it is the secretary and not a programmer...I know > this because I am the only one (sort of). In any event, I am running > really behind on another project...as usual...and just want this one to > 'go away' for the moment. Which leads me to my stupid question..... > > She wants to bring a balance over from one table into a form that uses > another table as its source. How do I reference the field? Simple > right? > > I have tried : > > StartBal = Tables![AcctBalances]![AcctBal] > > and it 'does not recognize the field 'Tables'. Keep in mind that my > head is throbbing at the moment, and I have a night of overtime planned. > Please tell me that I don't have to go through the whole rigamaroll of > declaring the Database and Tabledefs. > > Thanks in advance!!! > > John W Clark > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com