disconnected reorcdset (or something)

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

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
 
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.
 
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.
Click to expand...
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.
 
Use two forms - data entry & data verification.

mcnewsxp said:
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.
Click to expand...
 
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...
 
Back
Top