Recent content by Rick Blaine

Thank you CJ. You got to the nub of the problem with an excellent solution. Rick

Plog, thank you for your response. First - unbound form is not necessary, just desired. Second - Table 1 carries general information. Table 2 carries unique information related to Table 1. There can be any number of entries in Table 2 that relate to a particular entry in Table 1. Third -...

I have two tables that I want to update from data in an unbound form. How do I capture the ID of the new record created in table 1 in order to write it to a field in the new record being created in table 2. Table 1 id f1 f2 f3 and so on Table 2 ID Table 1 id F2 F3 and so on...

I work for the United States Environmental Protection Agency Region 9 (San Francisco). I have 30 years experience with PICK O/S. No one uses PICK anymore. So I have been learning MS Access in addition to Excel. I have done extensive programming in Excel VBA but virtually none in MS Access...