load form

[Guest]

Hi

On my main menu i have a command button which loads a form another based
upon staff member selected in a combo box.

My Problem is is the if the staff member selected has no records in the
query, when it brings up the next form it leaves the staff member blank. I
would like it to put in the staff member and show that there are no records
currently there and ready to enter a new record.

If there are records already there for a staff member its fine it loads the
form and puts the staff member in the field at the top and shows all records
for the staff member in the sub form.

Can someone help

Thanks

 

[Guest]

Open your query in design view and make it left join from member table to
records table so you get all records from the members table and only those
that match from the records table.