Clearing text field on a form after feeding data to an access query

[xredvette6]

I am stumped by something I would not think should be so difficult. I am using a small form with one text box which is populated by a user to set the value for a data query in Access (the query is based on [forms]![IDForm]![CustRefType] - my lookup form is [IDForm] and the criteria is [CustRefType]. The query returns a record in another form which the user uses to update the record. I need to be able to get the original text box value cleared so when the user closes the record form he/she has a clear text box to enter the next record ID to be queried on.



This is going to be a web database so I have to get this done via a macro. I cannot locate the code to get this done - either based on the click event of the search box form or the save/close event on the record update form.

Any help would be appreciated.

[pbaldy]

It would either be SetValue or SetProperty in a macro.

[ssanfu]

Just curious..... the control you want to clear is unbound, isn't it???

[xredvette6]

It would either be SetValue or SetProperty in a macro.

Neither of those options are available in the macro string. I would normally use SetField but that is not an option either.

[xredvette6]

To be honest I'm not sure. I created a one field [CustRefType] form with a cmd [Search] button. I have a query that points to the CustRefType on the form as the criteria for pulling up the corresponding record. I created a form to show the results of the query. The Search button on the first form opens the query form and does show the correct record information. My issue is when I save and close the main form the original information typed into the CustRefType field on the search form is still present. I would like to have that field blank and awaiting the next entry.

[pbaldy]

Make sure you've clicked on Show All Actions on the ribbon.

[xredvette6]

It is. For some reason the macro will not give me the options normally associated with setting a field value.

[pbaldy]

Can you post the db here?