RecordSource Problem!

[pgp]

Hi,

I have a main form " createquote". I want some of the
fields' record source to be one table - quoteheader and
some other fields' record source to be customer table.

Right now I make the entire form's record source as
quoteheader table.

How can I do this?

I would appreciate any ideas
Thanks in advance

 

[Dugantrain]

If the two tables relate to each other, you can write a query which selects fields from each table and then base your form off of that query.

 

[pgp]

Customer Info not updating!

Hi,

I did make these 2 tables related using a common field - customer number.

I created a query - using these 2 tables displaying all fields in both tables.

I did make form control's record source property as this query.

The problem is I have a combo box that has a list of all the customer names I can choose from, Once I choose one customer, how do I update the rest of cutsomer related fields using this query?

On the form, I did make all the customer related fields' control source - the appropriate fields from the drop down list in the property.

Problem is: When I choose a customer name from combo, I dont get the other customer related fields updated?

Thanks for your help!!

 

[Dugantrain]

The third option for the combo box Wizard can do this, but sometimes it doesn't work quite the way that you want it to. Either way, here's the code that you'd need:

Private Sub Your_Combo_AfterUpdate()
'Finds a record on the form by clicking on the combo box.
'This combo box matches its unique ID with the Form's Unique ID
'In this case, the unique id is [Install_ID], but yours will probably 
be something like Customer_ID.  If you don't have a unique ID in 
your Customer table, it'd be a good idea to add one.
Dim rs As Object
Set rs = Me.RecordsetClone
rs.findfirst "[install_id]=" & Me![Your_Combo]
Me.Bookmark = rs.Bookmark
Set rs = Nothing
End Sub

 

[pgp]

Thanks

It worked!!

Thanks a bunch for yur help !!