Open form to specific record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wylie C - 27 Oct 2004 19:09 GMT

I want to open a form to a record specified by the user through an input box.
The control on the form that contains the number is txtProject. Here is the
code I am trying to make work:

strProjNum = Val(Inputbox("Enter project number","Project Number:"
DoCmd.OpenForm"ProjectsForm",,,"txtProject" & "=" & strProjNum

Thanks

Reply to this Message

Steve Schapel - 28 Oct 2004 07:39 GMT

Wylie

Is the data in the txtProject field a number or text data type?

Signature

Steve Schapel, Microsoft Access MVP

> I want to open a form to a record specified by the user through an input box.
> The control on the form that contains the number is txtProject. Here is the
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Wylie C - 30 Oct 2004 07:47 GMT

Steve,
It is a number field.

> Wylie
>
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

Steve Schapel - 30 Oct 2004 09:00 GMT

Wylie,

Ok, so as far as I can make out, the code would be like this...
Dim strProjNum As Long
strProjNum = Inputbox("Enter project number","Project Number:")
DoCmd.OpenForm "ProjectsForm", , , "[txtProject]=" & strProjNum

Signature

Steve Schapel, Microsoft Access MVP

> Steve,
> It is a number field.

Reply to this Message