form population

[ecapox via AccessMonster.com]

i am looking to do 2 things with a form.

1. Edit existing records in a database
2. add new records to the database

I have a combo box, cmbEditAdd, that dictates whether i add a new record or
edit existing records, and i have a combo box, cmbMemoID, where i can select
the memo name of the memo i want to edit.

If i select "edit" from cmbEditAdd, and selcect Tax0702 from cmbMemoID, I
would like all the fields in the form to populate with the data from that
memo. The populated data is dependent on the cmbMemoID combo box.

If i select "add" from cmbEditAdd, i would like form to NOT populate with
anything so that i can enter in this information for the new memo. The
entered information would be stored in the table.

make sense?

 

[Guest]

Hi ecapox...

You could use the docmd.gotorecord acnew method to jump to a new record, and
use docmd.findrecord to move to an existing record.

Put these events in the after update event for the EditNew and ID number
combos respectively.

Damian.

 

[ecapox via AccessMonster.com]

awesome. i was adding other things to the docmd.gotorecord and it was giving
me problems.
this works wonders.

Emanuele

Hi ecapox...

You could use the docmd.gotorecord acnew method to jump to a new record, and
use docmd.findrecord to move to an existing record.

Put these events in the after update event for the EditNew and ID number
combos respectively.

Damian.

i am looking to do 2 things with a form.

[quoted text clipped - 14 lines]

make sense?