Hi,
I have a query that runs when a user clicks a button on my main form. At the moment the query uses one of the fields on my form as a criteria (users type a date into the field) and everything is fine.
However my form also contains a field that holds an autonumber ID for the currently displayed record. I'd like to get that autonumber into the results of my query (not as a criteria). Thing is that when i try to do something like:
in my query as a field name the results for that field in the query show a wierd square character? I just want the ID number from the form listed in the query result field...
Any suggestions?
I have a query that runs when a user clicks a button on my main form. At the moment the query uses one of the fields on my form as a criteria (users type a date into the field) and everything is fine.
However my form also contains a field that holds an autonumber ID for the currently displayed record. I'd like to get that autonumber into the results of my query (not as a criteria). Thing is that when i try to do something like:
Code:
MyID: [Forms]![Inventory_Receive]![ItemID]in my query as a field name the results for that field in the query show a wierd square character? I just want the ID number from the form listed in the query result field...
Any suggestions?
