open a form in edit mode without any values showing

S

StuJol

i have a form designed as an address book, when i open it from the
switchboard in edit mode, the form displays values in the fields. i use a
combo box to select the customer from my address table. what i want is for
the form to open in edit mode so i can search records but to open without
displaying any records until i select one from my combo box
 
A

Allan Murphy

When you open the form you could use code to set your field properties so
that the fields would not be displayed then after your select a name the
fields will be displayed

something like this
sub form_load()
Me!fieldname.Visible = False
label_name1.visible=false
( enter other field names and labels as required)
end sub

sub combobox_name_afterupdate()
Me!fieldname.Visible = true
label_name1.visible=true
( enter other field names and labels as required)
end sub
 
Top