Dear Jim,
I tried using the ID source from the Donors table instead, but it would not pull in the name and adress automatically. The ID number in the Donations table is part of the "Many" side of the One-to-Many relationship. The ID number in donors is the "One" side. I...
Gus...
Thank you very much. Your example helped me to realize the answer to my problem. What I was really looking for was an Auotlookup query that enters data automatically in new records. I almost have it completed, with one small problem:
There are now 2 separate tables, 1 that has an ID...
Thanks for replying, but that's not quite what I need. Sorry I was not more clear. In a new record, I need to be able to have a user type an alpha numeric value in a combo box. This value is a preassigned number that represents an individual or company. When they type in this number, it should...
I cannot seem to get around this problem. I have a table that contains a text field that holds combinations of numbers and symbols. When I make a new record, I would like to partially type in the number, let Access autoexpand it, and populate this field, as well as name, address, etc. Using the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.