Button on Subform to pickup ClientVisitID as Key

[joefonseca79]

I was wondering if someone could give me some advise on what I’m doing wrong.



I have 3 tables
Client
Type: AutoNbr Txt
Fields: ClientID, Name
ClientVisit
Type: AutoNbr Nbr Nbr
Fields: ClientVisitID, ClientID, VisitNbr
ClientImg
Type: AutoNbr Nbr OLE
Fields ClientImgID, ClientVisitID, Image

I have 3 forms
Client
ClientVisit
ClientImg

Client is the main form and has ClientVisit as the subform. They are keyed on ClientID

Inside ClientVisit I have a button that I want to open FormClientImg taking the ClientVisitID and populating it for the ClientImg table.

I have attached a sample db for reference


I can send a sample db if anyone needs or ping me back for any other questions.

Thanks in advance.

Joe

[NTC]

sorry, I don't look at attachments. Not sure I understand but once the new FormClientImg is open then it is a matter of selecting a trigger event - perhaps the user will always be keying in some field; and in that event simply write the ID by calling it from the other open form. Here is the syntax:

Me.IDcontrolname=Forms!ClientFormName.ClientIDCont rolName

hope this helps.

[joefonseca79]

I tried the following but i'm getting a run-time error 2450. Can't find the form 'FormClientVisit' referred to in a macro expression or VB code..

I added this to the FormClientVisit On Open

Private Sub Form_Open(Cancel As Integer)

''This syncs the id's
Me.clientvisitID = Forms!FormClientVisit!clientvisitID


End Sub

[NTC]

FormClientVisit On Open ?? if the form is not yet open then you can't refer to a control on it.

[joefonseca79]

So I need to put that code on the button that they click to open the subform?

[NTC]

ClientImg must have cross reference to client via the ClientID. right? so you need to put the ClientID value into a field in ClientImg - - some how, some way. b.t.w. I don't see a ClientID field in ClientImg. That is the fundamental point. I don't know the particulars of how the user is going to interact with the application. My first post gave one example of doing it by triggering a call of that value when one is in ClientImg. When you put in the image info - you need also to put in the ClientID value.