Form Not Opening Correct Record

[halfaguava]

Hello,



I have two forms:

1. A list of multiple records
2. A Data entry form

When a user double clicks on a record from form 1, form 2 opens and allows them to view and edit this record.

However double clicking always opens the first record, not the record clicked on

This is the macro I used....

If Not IsNull([BuildingID]) Then

OpenForm

Form Name: RecordOpen
View: Form
Where Condition: == "[BuildingID]=" & [BuildingID]

End If

I had to type that out, as it Office 2010 has an awful macro tool thing.

I copied this from a template which works, why doesn't it work for me!?


Many Thanks

[orange]

You might want to investigate using vba.

You can put controls on your forms and Access will generate vba code for various Events. You can adjust the generated code to include things you want.

There is a DoubleClick event and a button has a Click event.
You can Docmd.OpenForm "yourForm,,, and identify the record to be opened.....


There are some very useful, FREE video tutorials at dataPig.
see http://www.datapigtechnologies.com/AccessMain.htm

Good luck.