open a form in edit mode without any values showing

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

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

Top