disconnected reorcdset (or something)

[mcnewsxp]

i need to be able to create and empty recordset object that can be bound to
a form to be used in a double entry application. the forms are bound to a
main table for the first pass of data entry and for editing. i need to be
able to use all of the coding that exists for record and form navigation
with the disconnected or empty recordset object.
any hints?
tia,
mcnewsxp

 

[Guest]

You might try another way. Create a temp table for first data entry. Create
a second temp table for verification entry. One the second entry form have a
command button for when the second entry is finished to run a query to
compare the two temp tables. If they compare then append to production table
and delete records in the temp tables. If some records do not compare
generate a report for supervisor review.

 

[mcnewsxp]

You might try another way. Create a temp table for first data entry.

Create
a second temp table for verification entry. One the second entry form
have a
command button for when the second entry is finished to run a query to
compare the two temp tables. If they compare then append to production
table
and delete records in the temp tables. If some records do not compare
generate a report for supervisor review.

i thought of using a temp table.
what i need i guess is way to tell the form to use the temp table instead of
the main table.
i inherited this ADP app and the developer created his own classes for form
and record navigation.
so what i think i need to know is how to tell the forms to use another
record source.
there are too many form to use duplicates.

 

[Guest]

Use two forms - data entry & data verification.

i thought of using a temp table.
what i need i guess is way to tell the form to use the temp table instead of
the main table.
i inherited this ADP app and the developer created his own classes for form
and record navigation.
so what i think i need to know is how to tell the forms to use another
record source.
there are too many form to use duplicates.

 

[mcnewsxp]

too many forms.
i'll think of something.

Use two forms - data entry & data verification.

 

[Albert D.Kallal]

You, can certainly have 5 tables all of the same design, and attach a ONE
form to work with any of the tables....

just go

me.RecordSource = "select * from table1"


and...later on, to use another table for the same form...

me.ReocrdSource = "select * from table2'

So, it is very easy to change the table a form uses...