Search results

Thanks for the input. I agree DoCmd.GotoRecord seems like a good choice. I just haven't figured out a nice way to figure out which record I would like to go to.

That is the way I am doing it currently, but when it opens the new form, it filters the records and only that one record is available without un-filtering. Is there a way so it will not filter the records? I want to open the form and goto the record of interest.

I have two tables with a one-to-many relationship (it is actually a one-to-zero or one relationship). I have a form for each table. I would like to have a button on Table1 that goes to the corresponding record of Table2 or make a new record if it does not exist. I am currently using...