Data input from a query and user

[Jacqueline]

My Access skills are really rusty and have to admit to being embarrassed I cannot figure this out. Here is what I need to do in a form.

1. instructor will run a popup from dependent on the item number and quarter which will bring up a class roster.

2. The input form is based on a table where grades will be stored. I need the first three fields to be filled in by the popup query to cut down on instructor input time. Student ID, class item number, academic quarter, and instructor name.

3. The instructor will then fill in the grade, a y/n progress, and notes if there are any.

I tried using a continuous form but it only gives me one record from the roster run by the query. I am known for thinking of the hard way to do things so any suggestions would be welcome.
Thank you,
Jacqueline :banghead:

 

[Ranman256]

When you click the button to open the form, 1st run an update qry using keys needed.
Then open the form,
Docmd.openquery "quPreFill"
Docmd.openForm "frmEnterData"

 

[Galaxiom]

Can be all be done in the form. Much more elegant than using an insert query to partially fill records. Records are only added to the table as they are filled in.

Moreover it supports the validation of record completeness and uniqueness at table level which is not possible when done with the partial fill query.

Rough demo attached.

 

[Dick7Access]

Can be all be done in the form. Much more elegant than using an insert query to partially fill records. Records are only added to the table as they are filled in.

Moreover it supports the validation of record completeness and uniqueness at table level which is not possible when done with the partial fill query.

Rough demo attached.

Thanks, big help. I can see, my not so much coding error, as a basic design flaw.

It's funny I could probable a lot easier just right down on a pad what pills I took, but Access being part of my ministry and my hobby I like creating problems for myself and then, googling and searching my books, or with help from you people solving them and increase my Access knowledge.