coding question

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

What code do I need to use so that when a command button it is clicked, the
contents of a text box are cleared (not deleted completely from the
corresponding table, simply cleared on the form).

Thank you for any assistance.

LB
 
Is the form and text box bound to a table? If so, clearing the field will
clear the record.

Rick B
 
No, it's not bound, it's just an input for a query.
After the user closes the query and returns to the query input form, I want
all boxes to be blank.
 
In code you would just put something like the following. Not sure if you
want to tie this to a button, or how you want it to happen.




Me.SomeFieldName = ""


Rick B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form question 1
form/subform text box interactions 1
duplicate entry message 1
common fields 1
coding to export to Excel 1
Database duplicate entries 5
coding help 1
coding help 3

Back
Top