Clear fields in a form

[dmoran]

I know that this has been a subject here before, but I could not find a solution applicable to me - I have a DB where 1 person enters records. I then have users on a network who are linked to the table. The form gets its record from a single combo box entry - easy enough. Because the "user" needs only to lookup a street name in the combo box and view the record, I have a button called "search" that requeries the form and "clears/resets" the combo box(txtcombobox=null). To minimize confusion, I would also like to "clear" the form fields before the new street is selected. I don't need a new record because the user will not be editing/adding anything. I'm fairly new at this and have limited VB skills but am willing to try any suggestions. Thanks in advance - David

 

[randy700]

Dim ctl As Control
For Each ctl in Me
   If ctl.ControlType = acTextBox Then
      ctl.Value = ""
   EndIf
Next ctl

 

[RoyVidar]

Just popping in - are you sure you really want to clear all controls vs goto new record?

Reason I ask is that if this is a form bound to a table/query, then clearing all controls this way will delete all values for the current record.

Another thing, if any of the text controls on the form has a calculated controlsource, then it'll bomb, "can't assign a value to this object".

This can be avoided with adding a little test:

[tt]if left$(ctl.controlsource,1)<>&quot;=&quot; then
'... and proceed[/tt]

Last issue, if the primary key is an Autonumber, you'll get the same error there too (probably some ambiguities with other datatype PK's too). There I don't know any other workaround than to clear by deleting the whole record.

Roy-Vidar

 

[dmoran]

Thanks Roy - I think that will be the solution. I thought about the AddNewRecord option but thought it might keep adding blank records every time a user searched for a record - but thats not the case since there will be no data added. Thanks for the help. David