Search results

I have two tables linked in a one to many relation for referential integrity. Using a form, I try to enter an id in the many table that does not exist in the one table. Naturally Access give me an error message just as I expect it to. I want to set up error handling so that when the invalid...

I want to use VBA to get the data from one record in a table and store the results in variable that I can use throughout the rest of the application. I have an unbound text box where the user enters the text I want to select on. I tried using the docmd.runsql to select the record but it only...