Perhaps not the best title for this issue, but here is my problem:
I have an Access 2007 Form that is bound to a Linked Table (ODBC). The primary keys in the Table are a Date field and a Number field.
Using the form controls at the bottom of the screen, I can add new records, and navigate to next / previous record. However, I want to be able to enter values in the "Date" and "Number" and have the form display the correct record. If there is a record with the primary key of the values entered, it will take me to that record...if not, it will just start a new record.
What is a good way to do this? Do I need separate unbound textboxes for "Date" and "Number" that I can run a query from...this was my best idea but it seems like there should be an easier way.