executing update query

[deepucec9]

Hi,


I am trying to run an update query which updates the value in a sub form to another table. Set a macro "open query" to a command button, when I click on command button a pop up window appears with message "Enter parameter value (field_name)".
tried the same query in another FORM it is working fine. Please find the attached screen shot of query.
TIA

[pbaldy]

What field is in the prompt? The field highlighted above doesn't show as one of the fields, but there is one with a similar name.

[NTC]

a couple things:

in order to call in data from a form into a query you must have an alias like a calculated field; so it must be:
SomeName: [Forms]![FormName].ControlName

you have to have that 'SomeName:' preceeding it

then you must right click while in the upper half of design view and select: Parameters

in here you must enter the correct form field syntax i.e. [Forms]![FormName].[ControlName] and in the column next to it you select the field type that it is. You must do that for every field you are calling in.