seach subform record based on master form

[mfaisal.ce]

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,

 

[Gasman]

You need to link the master and child fields in the subform control. No filter required.

 

[jdraw]

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]

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]

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:-

Northwind Problem and Solution - Nifty Access

Northwind Problem and Solution If you use the Northwind database as a basis for your business application then there is a problem that you should be aware of. The sample Northwind database supplied by Microsoft provides some excellent insights in how you should program an MS Access application...

www.niftyaccess.com

 

[mfaisal.ce]

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]

Are you sure there are child record(s)?
Did you try requery once you select the combo value?

 

[Uncle Gizmo]

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....

 

[Gasman]

Crossposted with replies http://www.vbaexpress.com/forum/sho...-master-record&p=406206&highlight=#post406206

 

[missinglinq]

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)>