Its an Autofill issue, but a little different from the solutions i've seen

[dipo+]

Hi all,
Thanks for the environment to discuss Access issues.
I have tables and forms for updating the tables in a web database. One of such tables called TrackerT has TrackerID and UnitNumber as fields. My second table called InstallationDetails has among other fields a TrackerID field that I want to be automatically autofilled when I enter a UnitNumber in a text box I created on the InstallationDetails Form.
In other words, I want to extract the TrackerID from TrackerT table into the TrackerID field of InstallationDetails given the UnitNumber I type in the textbox I created on the InstallationDetails Form.
Your thoughts Pls. Thanks

 

[RenaG]

I had a similar question (if I understand your question correctly) and found this link in another post. Maybe it will help your situation:

http://www.baldyweb.com/Autofill.htm


~RLG