I have a form that is open with one record in the recordset. I need to
add a record to that recordset, then requery the form. Ultimately, the
user will --from a list on another form-- one-by-one, add records to
the forms recordset. Not new records, just other existing records that
need to be displayed.
It seems like this should be pretty simple. I could have the user open
multiple instances of the form, and that would actually be a better way
for the user, but I just thought this method would be simpler to code.
Can someone point me in the right direction, I'm not asking for code,
just a tip or two. I have searced this forum a lot, to no avail.
Thanks in advance,
Jeff Smeker