replicating a record: quick query

G

Guest

Dept, Subdept and costcentre are combo text boxes. I need to change the
following lines so that when the button is clicked it blanks the text boxes
in the new record.

!Dept = Me.Dept
!Subdept = Me.Subdept
!Costcentre = Me.Costcentre

thanks
 
J

John Spencer

When the button is clicked, set the combobox values to Null.
Me.Dept = Null
Me.SubDept = Null
Me.CostCentre = Null

Of course, you want to make sure you do that AFTER you move to the new
record. If you do it before, then the fields that are bound to the controls
will change on the current record. Something you probably don't want to do.
 

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

replicating a record: quick query. 1
Problem adding a new record. 14
I think I'm almost there...except for... 47
cloning a record 5
Uncertain of query results - can anyone advise? 3
Establishing a 1:m relationship using a query and a table 2
Key violation error when import from Excel. Please help.. 5
Query to identify key violation error when import from Excel. Pleasehelp.. 2

Top