Search results

Records appears more than once I have a query where the record appears more than once in the output when you run the query. Any suggestions. I could send the sql, but it is quite long.

Not having any luck using Me.Requery What I want to do in a form is add or delete from any existing record. Ex: If I want to add a name to a serial number or delete a name from a serial number. I am using a select query as the data source.

I have a form with a seledt query as the source. I have tried adding a command button to add and one to delete changing the code within it to Me.Requery. I get you can not go to the specified record when I try this. Any suggestions?