link a search form to data entry form with specific record

[lovedieer]

I have a search form (continue) contain basic information which allow people to filter to a specific record. I have another data entry form (single form) has all the detailed information. These two forms have the same data source. the PK for the table is ParticipantID

I add a macro (I do not much VBA codes) to participantID for the search form and hopefully it can open the data entry form for that participant if I click the ParticipantID.

the macro are: open form and I use where condition :
Forms![FrmSearch]![ParticipantID] = forms![FrmDataEntry]![ParticipantID]. however, it open a new record in the data entry form?

Can somebody tell me what's wrong with it?
Or write an code for me?
Thanks.

 

[pbaldy]

Is the data entry form's Data Entry property set to Yes? If so, you may want to change that or see if setting the datamode argument of your macro to Edit will override it.

 

[lovedieer]

Data entry property is set to "No" for the data entry form
The data mode for the macro is Edit.

 

[pbaldy]

Ah, I think your syntax is off. You want:

FieldName = FormReference

so change the first form reference to the appropriate field in the table. In VBA code, it looks like this:

http://www.baldyweb.com/wherecondition.htm

 

[lovedieer]

It works perfect now!.

I add your website as my favorite.

Thanks.

 

[pbaldy]

Excellent, glad we got it sorted out. Hopefully my site proves useful to you.