Open form from continous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, I have tried almost all code and still can't figure this out:

I have a form in continous view, a button to select the record next to it.

This button I would like to open another form based on the selected record.

Code i have tried:

DoCmd.OpenForm "HouseTest", , , "HouseIDNo = " & Me.HouseIDNo

When I click the button, it pops up with a Dialog box asking for parameters
of HouseIDNo.

Any help much appreciated, thanks

Scott
 
It's all OK. After spending something like 6 hours, i figured it out.

It works, it's all about getting those little quote's in the right place!
"""""""

Perserverence pays off in the end
 
Back
Top