Parameter not working in Update Query

[KCK]

I have two tables, Invoice and Frt_data. The two are linked using two fields (Customer_number and Process_date). I need to enter the month name in the 'AP_month' column of the Frt_data table based on the Invoice_nbr in the Invoice table.
I created an update query containing the fields Invoice_nbr and AP_month. In the criteria section of the Invoice_nbr field I have [Enter Invoice Number] which pullls up all the records with that invoice number. I want to be able to run the query so that it prompts me for the Invoice Number and then the AP month name that I want added to the AP_Month field. It seemed logical to simply enter [Enter AP Month] in the Update To box under AP_month in the update query but it does not work. When I run the query it asks for the invoice number but not the AP month. Fortunately it does not add [Enter AP Month] into the AP_month feld in the table!

I am trying to stay away from Forms as I am not very conversant with them and have not had much luck when I have tried them. A simple query would work fine for me at this point.

Can anyone help me understand why the [Enter AP Month] prompt does not work and how to fix it?

 

[Brianwarnock]

If the prompt was enclosed in quotes either the field would be updated or a type conversion failure would occur dependent on whether the 'AP_month' field was text or numeric.

I think that you are trying to execute the query by clicking on the view icon in the toolbar instead of the run icon, the large red !

Note however that you will be prompted for the [Enter AP Month] before the [Enter Invoice Number] , not what you want and another reason to get to grips with Forms. You wont learn if you don't try.

Brian

 

[KCK]

Thanks for the feedback. The database is for internal use only but I guess I will need to get more familiar with forms!