Call form variable in access query

Question

I have a text box on a form called

txtNID.

I want to use the value entered into this text box as a column in my query such that it would have the same effect as entering

NID: "1"

I tried using

NID: [Forms]![frmAddCorrespondence]![txtNID]

But it doesn't work. The query contains one column called CustID and I want a second column to contain the value of the txtNID textbox.

I also tried setting a function to define a variable for the column but my VB is so bad I just keep going around in circles! Here's what I did:

Public Function FrmNID()
varNID = Me.txtNID.Value
End Function

Then set the query field as =FrmNID() but it didn't work!

Could really do with some pointers! Thanks, Rob

Is the form open when you run the query? Is the field really named txtNID? Have you declared a parameter for it (it usually works without one, but it works more reliably with it)? — David-W-Fenton
– David-W-Fenton, Commented Mar 30, 2011 at 21:21

Kevin Ross · Accepted Answer · 2011-03-29 10:52:56Z

2

Your code should. I have just done this on one of my databases and it works find

Forms![frmStaff_admin]![txtCSR_name]

Just remember that your form has to be open!

answered Mar 29, 2011 at 10:52

Kevin Ross

7,2253 gold badges24 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1