Open For with Blank Fields

[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

 

[NoodNutt]

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.

 

[Tanya]

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