error when selecting code from a database

[CJ_London]

AAAndy, novice or not, what part of

= DLookup("intSubscriptionID", "dbo_tbl_Custom_Subscription_Subscriptions", " varReportTitle = '" & [iVal] & "'")

includes any reference to a form?



Perhaps you need to go back to the beginning and explain in simple English what you are trying to do, at the moment it's looking like you are trying to fit a round peg into a square hole. i.e. assuming the code we have been talking about does what you want - and it clearly isn't

[AAAndy]

AAAndy, novice or not, what part of

= DLookup("intSubscriptionID", "dbo_tbl_Custom_Subscription_Subscriptions", " varReportTitle = '" & [iVal] & "'")

includes any reference to a form?

Perhaps you need to go back to the beginning and explain in simple English what you are trying to do, at the moment it's looking like you are trying to fit a round peg into a square hole. i.e. assuming the code we have been talking about does what you want - and it clearly isn't

I'm just trying to display the value of the primary key on my form

[CJ_London]

this is where I'm getting confused - the normal way would be to bind the control to the primary key, but I think you already had that and it wasn't what you wanted as indicated in posts 9 to 11

[AAAndy]

this is where I'm getting confused - the normal way would be to bind the control to the primary key, but I think you already had that and it wasn't what you wanted as indicated in posts 9 to 11

I have about 2000 records in my database and the primary key is the only number that I can use to track everything. I don't want to change the primary key but just display it so that it can be written down and copied into a search form to access it if needed later. So I have all my fields showing up on the form with values from the database but the primary key value will not display. Currently in this form I have two drop downs that search for a certain title.

[CJ_London]

but the primary key value will not display

under normal circumstances you would not display the primary key since it is a meaningless number used only to uniquely identify a record and is (normally) of no interest to the user.

You are using 2013 so if the form was auto generated using a wizard the primary key is not included. To display it, in the form design view, on the ribbon, select 'add existing fields' then from the list displayed, drag your primary key field to where you want it on the form.

[AAAndy]

I will exclude the primary key. Thanks for all your help.