Tring to make a select query add/delete records

[Lamb2087]

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?

 

[3699wat]

To add a new record either add a command button with the appropriate procedure on the on click event. Your query will be updated when you close the form. If you want to update the query when clicking the ADD button again you have to add the
Me.Requery to the event procedure.
If you want to delete a record you have to select the record by either using the navigation buttons or import a listbox or combo box on your form. Again you will have to set the
Me.Requery
to the on click event of the form as well as to the box if appropriate.
Let me know if this helps

 

[Lamb2087]

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.

 

[Lamb2087]

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.

 

[Lamb2087]

Adding to existing record

I have made it so you can add a new record and delete a record. What I want to do is add or delete fields from an existing record.

I have another question in regards to bringing back more than one result of a record. I am bring a record back multiple times when I run the query. I am confused as what I need to do in the sql to fix this