Pull record with primary key and auto populate fields with restof data

[iteach2]

I have a form linked to a table called tblChange. The fields look like this

Change# Status Requester Type Contact# StartTime EndTime

StartDate EndDate


I have been trying to get this for weeks........


The Change# field is my primary key. Is there anyway i can input the change# and then auto-populate the remaining text boxes on the form with the corresponding data.

For example"
(table)
Change# Application Date Status
123456 Proxy Server 4/12/01 Pending


(form)

Change#
123456

...after inputing the change# i would want all the other info status, application, date etc. to appear in their appropriate txtboxes.......

---------------

Also...Can somebody show me how to create a continuous form and have that for open on a new record....

I am so new to access 97....this would really,,,really help me and the kids.... ya' know!!!!

 

[Robbo1974]

You could use a combo box on the form to select your value. If you use the combo wizard (make sure that the button on the toolbox with a magic wand is depressed when you place the combo) Access will do the rest for you.

The continuous form can be created by changing the Forms default view property to 'continuous forms'. You can then open this form at a new record from a command button - again if you use the wizard, Access will do the work for you!

Can't help too much more - I need a bit more detail on what you're wanting to do.

robbo ;-)