Form Update! (1 Viewer)

[pgp]

Hi,

I have a main form - displaying a quote header info and
subform - displaying related line items info.

When I open this form, I want to have a quotenumber
textbox and a combobox - revision number

When I enter a valid quotenumber, the combo box should
automatically list all the corresponding revsionnumbers
for that quotenumber.

How do I do this?

I tried using the RowSource = "Value List"
RowSourceType = Value from Table for RevisionNumber field!

It doesn't work!

I would appreciate any input/ideas!
Thanks in advance

.

 

[FoFa]

Base your Revision Combobox on a query that uses the text box as it's criteria (to pull those revisions for the proper Quote). When a quote number is entered, you then have to requery the combobox for it to "detect" the quote number.
Have you considered using a combo/list box for the Quote number as well?

 

[pgp]

Thanks!

Thanks Fofa!!
That worked! I appreciate your help

 

[pgp]

Subform Update!

Hi

This is in relation to my thread!
Now I have a combobox which gets updated with RevisionNumbers for the corresponding quotenumber I type in.

I have a subform with lineitem information for a given quotenumber & rev number

When I pick the quotenumber & revnumber, the appropriate lineitems must be shown in the subform.
Right now, it updates for one combination of quotenumber & revnumber values!

But for any other combination - it becomes empty!!

Would appreciate your input/ideas
Thanks in advance

 

[FoFa]

Requery your subform control when you select the revision number