open a form in edit mode without any values showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top