forms only show primary key

[Mindy]

Hey,

It's a Christmas Eve, but I still struggles with one problem. Hope can
get some idea from someone. Here is my question:

I have two forms, form A and formB, where form B is used to add data
into a database, let's say B_DB. when user pickup a member id on form
A, what I hope to see is on form B, the field "memberId" will show the
member Id picked on form A. and the rest of fields on form B will be
blank, where user can enter data. But the problem here is if the
"memberid" already has records in B_DB, on form B, all previous records
will show up too. I can add data using scroll bar to locate to the end
of a record. But that is really annoying. Does anyone know how to solve
it?

Thanks a lot and Merry Christmas!

Mindy

[pietlinden]

so you put a button on form A that opens form B and passes the primary
key of the form B's underlying table...

DoCmd.OpenForm "MyFormB",,,"memberID=" & Forms!MyFormA!MemberID

[Mindy]

Thank you. But my question is I only want primary key shows up on form
B while other fileds will be blank.

I tried two ways. If I open the form b with acformadd, form b is
blank, every field is blank.
If I open the form b with acformedit, all field are showed up . Thank
you.

[Mindy]

I get it. I accidently used list box instead of text box in form B.
after using text box, it is ok now. Thank you.

[pietlinden]

That's what it should do.
if you open a form in *add* mode, the only field that will be set is
the primary key. The rest you have to fill in. Makes sense, right?

If you open the form in Add mode and pass the primary key, you should
get what you want.