Solved Link to specific ID in other form (1 Viewer)

[Valient]

Good day to all,

I need assistance, being new to this environment hope someone will help. attached is sample DB for reference you can edit it direct here.

Here it goes:

I created "Base" & "Info" table and create their relationship.
Then created Form link to Base" & Info table.

The "Base Form is in continous format and I added a BTN.
The requirements is when I click the BTN, the specific ID link to it in "Info" will show up.

Thank you

 

[arnelgp]

you connect it using ID from table Base and BaseID from table Info.
do not Connect on both ID (since both are Autonumber).

 

[Valient]

you connect it using ID from table Base and BaseID from table Info.
do not Connect on both ID (since both are Autonumber).

Hi it works as per the attachment.
May I know where did you get the value "txtBaseID" that you put in the event?

"BaseID= " & Me.txtBaseID


I asked this because I transfer the coding to our database and it shows error and highlighting the "txtBaseID"

 

[arnelgp]

see the Base form in design view. there is a Yellow textbox there (visible=false).
that is txtBaseID whose ControlSource is BaseID.

 

[Valient]

see the Base form in design view. there is a Yellow textbox there (visible=false).
that is txtBaseID whose ControlSource is BaseID.

Thank you arnelgp, got it

 

[Valient]

hi,

im sorry to open this topic again.

The attached DB is working really fine. As shown, up to letter D (Figure1), it display the specific ID.
But when it reached the letter E (Figure 2), all the values that I put from letter E to H does not display.. It always display as blank page.

Could you please help to check whats the issue?

Figure 1

Figure 2

 

[arnelgp]

because there are no corresponding record in Info table.
you need to add records to table Info first.

 

[Valient]

Thank you very much. solved