Create new record using a form based on an existing record

[Guest]

I have a form based on a query. I need users to be able to create a new
record in the table the query is using, but instead of all the fields in the
new record being blank, I need the form to already be populated, but the user
needs to be able to change any of the fields. Any idea how I can do that?

Thanks,
Alex

 

[Guest]

I did this by using a command button that duplicates a record. Thank you.

 

[Guest]

hi alex,

this is pretty much what i'm trying to do....

the users are clamoring for an ability to 'conditionally' duplicate a record
whenever a listbox is checked 'Yes'. i can see a command button working into
the scenario, but your posting's a little murky about the exact details. can
you flesh it out some.

looking forward to your reply,

ted