seach subform record based on master form (1 Viewer)

mfaisal.ce

Member
Local time
Today, 08:37
Joined
Dec 21, 2020
Messages
76
Hello

I have a subform and i need to change record when i change master form record.... but when i change master form record, subform record doesnt change... i tried with filter option but useless... kingly guide...

regards,
Screenshot.jpg
 

jdraw

Super Moderator
Staff member
Local time
Today, 01:37
Joined
Jan 23, 2006
Messages
15,364
Seems you are new to the forum and are dealing with Inventory/Stock Control. You may get some ideas from these links:
Allen Browne AppInventory
Software Matters Stock Management

Good luck with your project.
 

mfaisal.ce

Member
Local time
Today, 08:37
Joined
Dec 21, 2020
Messages
76
Dear, during navigation of master record, child form record changes. but during change of master record by combox box (master field), child records dont change...... this is my problem....
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 05:37
Joined
Jul 9, 2003
Messages
16,245
Could be there is no related record.

You might be changing the data with your combo.

See here for an explanation of what I mean:-

 

mfaisal.ce

Member
Local time
Today, 08:37
Joined
Dec 21, 2020
Messages
76
dear if u have combobox as unbound control, it works fine. but if u have bound combobox, it did not retrieve child records in subform
 

jdraw

Super Moderator
Staff member
Local time
Today, 01:37
Joined
Jan 23, 2006
Messages
15,364
Are you sure there are child record(s)?
Did you try requery once you select the combo value?
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 05:37
Joined
Jul 9, 2003
Messages
16,245
dear if u have combobox as unbound control, it works fine. but if u have bound combobox, it did not retrieve child records in subform

See my website linked to in previous post....
 

missinglinq

AWF VIP
Local time
Today, 01:37
Joined
Jun 20, 2003
Messages
6,423
dear if u have combobox as unbound control, it works fine. but if u have bound combobox, it did not retrieve child records in subform
When using a Combobox to retrieve Records...the Combobox must be Unbound!

Using a Bound Combobox, as you're attempting, isn't retrieving the Record...it's editing the value of the Field that is Bound to the Combobox in the Current Record.

Linq ;0)>
 

Users who are viewing this thread

Top Bottom