Setting the value of controls in a form to null

  • Thread starter Thread starter Geo
  • Start date Start date
G

Geo

In a form, in an MS Access 2002XP form (having as record source a table)
with:
-6 combo boxes with values selected from a query (ex: For cboBox1 record
souce is the field NAME from the table, Row Source Type "Table/Query", Row
source like "SELECT DISTINCT Query1.NAME FROM Query1")
-1 from a table
-4 text boxes with values I will introduce,
how can I, after saving the data in a table, set to null the combo boxes,
for having all the controls blank for introducing the next record in the
table?
Thank you!
Geo
 
All you need to do is set the control to Null:

Me.cboBox1 = Null
 
You must log in or register to reply here.

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

Access Control on subform / combo box requesting parameter 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Command buttton code for addding data in an Access 2002XP table 2
how to pass a parameter to a query base of a query that is the base of a report 0
Form Problems with Combo Boxes 3
Problem with Combo box on form 1
Control Box QUERY/MACRO Question 6
Form automatically adds new record 2

Back
Top