Open For with Blank Fields

  • Thread starter Thread starter Tanya
  • Start date Start date
T

Tanya

Hi
I have a form named Uniform and a subform named uniform subform and the main
form has student names only which I don't want to open in add mode, only for
viewing, the subfield is working perfectly, what I would like is for the
student names in main form to be blank when the form opens.

I have read many responses on this forum about opening forms with blank
fields where user wants to create a new record, but in this case the only new
record will be in the subform, based on search on main form.

Can someone please advise me?

Kind Regards
Tanya
 
G'day Tanya

In your main form, I assume your Student name field is a textbox.

I recommend changing it to a combobox, then all you have to do is select a
student from the dropdown and go to your subform to enter the new record
details.

HTH
Mark.
 
I happy with using a textbox and I have a command button which allows the
user to search for a student, without having to scroll.
My first version of this database opened with blank text fields and I can't
find what I am doing differently.

cheers
Tanya
 
Back
Top