Open form from continous form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IscaComps - 02 May 2005 21:16 GMT

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

Reply to this Message

IscaComps - 02 May 2005 21:31 GMT

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

> OK, I have tried almost all code and still can't figure this out:
>
[quoted text clipped - 12 lines]
>
> Scott

Reply to this Message