show data from subform in master form

[Zedbiker]

Hi
I have a master datasheet view form with a subform linked by a part name.
The master form needs to be editable via combo boxes. I want to show on the
master datasheet form a stock value which is held on the subform.
I have tried using a query but that locks the combo boxes.

I would be grateful for any advice. Simpler the better
Many thanks

 

[Michael J. Burgess]

Hi
I have a master datasheet view form with a subform linked by a part name.
The master form needs to be editable via combo boxes. I want to show on
the
master datasheet form a stock value which is held on the subform.
I have tried using a query but that locks the combo boxes.

I would be grateful for any advice. Simpler the better
Many thanks

 

[John W. Vinson]

Hi
I have a master datasheet view form with a subform linked by a part name.
The master form needs to be editable via combo boxes. I want to show on the
master datasheet form a stock value which is held on the subform.
I have tried using a query but that locks the combo boxes.

I would be grateful for any advice. Simpler the better
Many thanks

What are the Recordsources of the mainform and subform? As a rule a Mainform
will be the "one" side of a one to many relationship, and the subform the
"many" - so each record on the main form will have zero, one, or *many*
records on the subform. As a result the stock value on the subform is not well
defined - there may be no record on the subform, or there might be twenty!

What are your tables? How are they related? What information are you trying to
display, where and why?

 

[Zedbiker]

Hi John
Sorry for the lack of information. Easy when it is in front of you.

I have a master form which shows order information for parts from the
workshop (table). This is shown in datasheet view. Each record needs to be
editable such as status of order (combo box), urgency (combo box), quantity
ordered (text box) and order complete (tick box).

This is linked by its part name to a subform which shows information for
each part (table), this includes the workshop stock level.

The user would like to be able see the stock level on the master form to see
when the stock level needs to be increased.

I hope this makes more sense.

Thank you.

 

[John W. Vinson]

Hi John
Sorry for the lack of information. Easy when it is in front of you.

I have a master form which shows order information for parts from the
workshop (table). This is shown in datasheet view. Each record needs to be
editable such as status of order (combo box), urgency (combo box), quantity
ordered (text box) and order complete (tick box).

This is linked by its part name to a subform which shows information for
each part (table), this includes the workshop stock level.

The user would like to be able see the stock level on the master form to see
when the stock level needs to be increased.

I hope this makes more sense.

No, since you cannot (to my knowledge) put a Subform control on a datasheet!

Is this really a Subform? Or a separate standalone form that you are opening,
or that you have open?

If you just want to see one field (the stock level) from the parts table on
the order form, you could use a calculated field in that form's recordsource
query using DLookUp() to look up the stock level, rather than some sort of
subform.

 

[Zedbiker]

Thank you for your help. I shall have to rethink my methods.

Thanks again.