synchronising records

[ccs2]

I have a list in a tabular form showing bookings called frmEdit/Delete which I have set properties to prevent edits. I want the user to be able to select a record from the list then go to another form called ,frmBookingsEdit, in Columnar format to edit the individual record. At the moment when the user clicks the button which runs a macro to open the second Form it only ever displays a blank record. I've tried using the Access help which seems to suggest modifying the Where Condition in the Macro but I think I am getting the syntax wrong in the expression builder. Any ideas?

Cavan Stewart

 

[quest4]

Cavan the trouble with macros is they are not versitile enough at times, and this is probably one of them. I would probably use some VB in the OnClick event of the command button, which if I understand you is what open the second form. Try something like:
DoCmd.OpenForm "Form2", acNormal
Me.BookName1 = Form!Form2!BookName2
DoCmd.Close acForm, "Form1"
You will have to substute your field and form names, but I think this will get you close. You may need to tweek line two some, but that should do it. Hope this helps a little, good luck.