Retrieve data into form and pass data to table

[Guest]

I'm not sure if this is the correct place to post this but I need help to
learn how to create an entry form. I want to have the user:
1.) Type in a Work Order #
2.) Push a command button that reads the WO# field
([forms]![frmEntry].[WO#]) and have relevant info into fields in the form.
3.) Then the user will add more info.
4.) I'd then like all the data added to a table. (yes, i know that flat
tables are bad! but it's not my choice) either by an ADD DATA command button
or exiting or going to the next record form.
I am not good with VBA but good with queries. Can someone give me direction
or is there a good article on this?

 

[dcichelli]

I'm not sure if this is the correct place to post this but I need help to
learn how to create an entry form. I want to have the user:
1.) Type in a Work Order #
2.) Push a command button that reads the WO# field
([forms]![frmEntry].[WO#]) and have relevant info into fields in the form.
3.) Then the user will add more info.
4.) I'd then like all the data added to a table. (yes, i know that flat
tables are bad! but it's not my choice) either by an ADD DATA command button
or exiting or going to the next record form.
I am not good with VBA but good with queries. Can someone give me direction
or is there a good article on this?

Hi Jackle -

Maybe I am missing something but your question seems pretty easy to
answer.

Take your table and create a select query with every field from the
table. Under the criteria section of the WO# field in the query put
[Please enter a WO#:]

Make this parameter query the underlying source of your data entry
form. Each time someone opens the form, they will be prompted to enter
a WO#. After entering the WO#, the form will populate with the
associated data.

You can get fancier with VB...but start there.

Diane

 

[Guest]

I thought of doing it this way but that means doing 100 or so records at one
time. that's a lot of opening & closing of forms. If i could have a parameter
field on the same form and have a command button populate the form (or dump
data into the table and requery the form?), that'd be ideal. I'll also have
an 'add a record' command button to go to the next (blank) record.

I'm not sure if this is the correct place to post this but I need help to
learn how to create an entry form. I want to have the user:
1.) Type in a Work Order #
2.) Push a command button that reads the WO# field
([forms]![frmEntry].[WO#]) and have relevant info into fields in the form.
3.) Then the user will add more info.
4.) I'd then like all the data added to a table. (yes, i know that flat
tables are bad! but it's not my choice) either by an ADD DATA command button
or exiting or going to the next record form.
I am not good with VBA but good with queries. Can someone give me direction
or is there a good article on this?

Hi Jackle -

Maybe I am missing something but your question seems pretty easy to
answer.

Take your table and create a select query with every field from the
table. Under the criteria section of the WO# field in the query put
[Please enter a WO#:]

Make this parameter query the underlying source of your data entry
form. Each time someone opens the form, they will be prompted to enter
a WO#. After entering the WO#, the form will populate with the
associated data.

You can get fancier with VB...but start there.

Diane

 

[dcichelli]

I thought of doing it this way but that means doing 100 or so records at one
time. that's a lot of opening & closing of forms. If i could have a parameter
field on the same form and have a command button populate the form (or dump
data into the table and requery the form?), that'd be ideal. I'll also have
an 'add a record' command button to go to the next (blank) record.

I'm not sure if this is the correct place to post this but I need help to
learn how to create an entry form. I want to have the user:
1.) Type in a Work Order #
2.) Push a command button that reads the WO# field
([forms]![frmEntry].[WO#]) and have relevant info into fields in the form.
3.) Then the user will add more info.
4.) I'd then like all the data added to a table. (yes, i know that flat
tables are bad! but it's not my choice) either by an ADD DATA command button
or exiting or going to the next record form.
I am not good with VBA but good with queries. Can someone give me direction
or is there a good article on this?

Hi Jackle -

Maybe I am missing something but your question seems pretty easy to
answer.

Take your table and create a select query with every field from the
table. Under the criteria section of the WO# field in the query put
[Please enter a WO#:]

Make this parameter query the underlying source of your data entry
form. Each time someone opens the form, they will be prompted to enter
a WO#. After entering the WO#, the form will populate with the
associated data.

You can get fancier with VB...but start there.

Diane- Hide quoted text -

- Show quoted text -

What do you mean by "doing 100 or so records?"

Do you have multiple records for each WO?

Can you give more information about your table(s) structure?