I have two live database tables linked to this access db. I'm doing a dlookup based on a query that is driven by the data a user types in, into an initial text box on the form.
For example, the user would enter an rx_num, based on that rx number 6 other fields are populated using dlookup...