Choosing an old record from a subform

[shawnvw]

My subform draws from a query which in turn draws from three tables. Its easy enough to add a new record in the subform, but what about when I need to add an existing record to the form? I can't enter the record number in the ID column because it's an autonumber field.

 

[boblarson]

What do you mean that you "can't enter the record number in the ID column because it's an autonumber field?" Are you talking about a field on the main form or on the subform? It shouldn't be necessary to add to an autonumber field. It should be added automatically when you enter any other field data to the record.

 

[georgedwilkinson]

My guess is that you're mixing up the idea of adding new records vs navigating to and modifying existing records.

If you're going to use the ID column to identify data in your tables to your users (which you shouldn't do), you can easily right click on the ID field and type in the ID in the "Filter for:" field to navigate to an existing record, thereby allowing you to edit said record.

 

[shawnvw]

My guess is that you're mixing up the idea of adding new records vs navigating to and modifying existing records.

I'm not mixing them up. I need to do both.

Originally I just entered data in the table. Recently I created the form and subform as a better way of accessing the data. The form is a "log" for each employee; the records in the subform are the individual log entries.

It works fine for adding new records, but there are many records in the table that are not yet associated with the appropriate log. In order to do so, I have been going to the table of log entries and filling in the "LogID" field that links the log entry to the appropriate log.

I can continue to do that, of course, but I'd like to be able to do on the the form, without having to go back to the table.

 

[georgedwilkinson]

And the underlying data for the main form is related to the underlying data in the subform through a relationship, right? And you have set the master/child linkage correctly on the subform(s) using that/those relationship(s), right?

 

[shawnvw]

As far as I can tell, yes. What next?

 

[georgedwilkinson]

No next from me unless the answer is "definitely, I double checked and all the linkages on the forms/subforms are correct and I was able to verify they work correctly."

 

[boblarson]

As far as I can tell, yes. What next?

If you still can't get it, perhaps upload the db (after removing any sensitive data):
How to upload a database to the forum