Append to Table based on results from form.

[mando63]

MSAccess 2013
Windows 7 professional

I have a search form where I type in partial lname, fname and/or employeeID. Let's say I get 5 records displayed by a form. I then want to double click on the record that I would like to append and this triggers an append query but it is currently trying to append all 5 records instead of the one record I double clicked on.

I would appreciate any assistance that anyone can provide.

Thank you in advance.

[NeoPa]

If you would like some help with some code that isn't working then you should post the code along with an explanation of what exactly isn't working. Line numbers are very helpful on that score.

[mando63]

Not using any code. Using a form to search for records and that search button opens up another pop up form that displays the records. I created an event on double click and just told it to open the append query.

[zmbd]

Yes you are running code; however, if you used the control wizards to create them then you are most likly using the Macro code language and not VBA.

Before we can help you we'll have to verify this:
Open the form in design view
Show the property sheet for the control
Events tab
On_Click event
[Event Procedure] = VBA Script
[Embedded Macro] = Access Macro Script



If you want to move to VBA then:

BACKUP THE DATABASE!
Once this is done it can not be undone and occationally things "break" in the process:

Convert the [Embedded Macro] to [Event Procedure] by:
Ribbon
Form Design Tools (context - Form must be selected and in design view)
Tools Group
Convert Forms Macros to Visual Basic.

You will need to do this for each form in the database.

[NeoPa]

Maybe I should put that in simpler terms :
Whatever you have that isn't working, we would need to see before we can be a great deal of help to you.

As previously, a clear explanation of what isn't working, preferably with related line numbers, would also be necessary.

Without such information the question would be analogous to "I have a problem. Please help me fix it." It leaves us with very little scope to help.