need to have pre populated data to upload

[sandeep0000]

using access 2003

i am creating a form, that has some data that is already in our database that will populate.

i know there is a way , when the form is opened, that all the data is available on the form that we can provide, other data will be manually entered.

so for when a person enters a cs_id , all the info we have gets populated.

but i would also like is that the person doesnt have to enter the cs_id, when the form is opened, that i will look at the view that i built and will grab all the cs_id and the fields that i can grab from the database to populate right when the form is open, not when the person enters the cs_id

so if i have 80 records, the form would have 80 records and they can tab to the cs_id that they want

 

[PHV]

Why not simply use a bound form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

hmmm
so in a bound form, the user doesnt have to enter anything , when the form is open , all the data that is in my view will populate the form? so if there are 80 rows in my view, it would have 80 different records . how do i do a bound form?

 

[PHV]

Simply follow the form wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886