Search results

I was using an autonumbered ID field to link the table to others. Some of my records have been deleted for one reason or another; so the ID numbers go from 7 directly to 13. Is there any way of adding a new record that reuses the ID of one of the deleted records? It would sure be easier than...

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.

LogsTable is accessed through a form. I need to add a combo box that lets me select a record from PaychecksTable, so I can assign a paycheck to that LogsTable record. I also want to see the fields from PaychecksTable on the form too. This should be easy. Part of my problem is the Combo Wizard...

I have a table, "Sessions", that has lookup fields which each pull in a value from the Employee, Checks, and Client tables. (They're each "one" to the Session table's "many". ) Because I'm moving to forms, I want to remove these fields - or at least, not use them any more. When I get the form...

Here's what I have so far: The form contains a subform, which draws records from the a form called "Sessions Subform". As you probably know, this form is a datasheet form (a form that looks like a table, which I think is cool), that draws its records from a table called "Sessions". The...