Open form a specific record - Newbie

[Guest]

Hello Newgroup:

In my app, the user may select a record from a "listbox" by double-clicking.
I would like to open and display the selected record on a new form.

When I use the "DoCmd.Open"

PolicyNumb = 4

DoCmd.OpenForm "sfrmCnfrmEntryPolicies", , , Forms![frmItemList]![Policy_id]
= PolicyNumb

Ms-Access 2000, prompts me for the value of "PolicyNumb", even though that
var has been set in the code.

Is this the best way to approach this problem ? Any suggestions or
recommendations are greatly appreciated.

Thank you in advance.

 

[Sandra Daigle]

Hi Darryl,

The Where Condition parameter uses a string that tells Jet (the database
engine) which field to check, what comparison to use and the test value. Try
the following:

DoCmd.OpenForm "sfrmCnfrmEntryPolicies", , ,"[Policy_id]=" & PolicyNumb

In the above, "[Policy_ID]" should be inside the quotes and should be
replaced with the name of the field you want to test.

 

[Guest]

This is working great Sandra! Thanks very much for answering my post.

Hi Darryl,

The Where Condition parameter uses a string that tells Jet (the database
engine) which field to check, what comparison to use and the test value. Try
the following:

DoCmd.OpenForm "sfrmCnfrmEntryPolicies", , ,"[Policy_id]=" & PolicyNumb

In the above, "[Policy_ID]" should be inside the quotes and should be
replaced with the name of the field you want to test.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hello Newgroup:

In my app, the user may select a record from a "listbox" by
double-clicking. I would like to open and display the selected record
on a new form.

When I use the "DoCmd.Open"

PolicyNumb = 4

DoCmd.OpenForm "sfrmCnfrmEntryPolicies", , ,
Forms![frmItemList]![Policy_id] = PolicyNumb

Ms-Access 2000, prompts me for the value of "PolicyNumb", even though
that var has been set in the code.

Is this the best way to approach this problem ? Any suggestions or
recommendations are greatly appreciated.

Thank you in advance.