Need To Double Click On Datasheet to change data On Main Form.

[hiker0310]

I have a main form named QLSalesFollowup. This Form has a subform in datasheet view. The Subform's name is QLSalesFollowupSF. If I open a quote on the main form the subform displays all the quotes we have sent to that customer. The two forms are linked with the customerID field. I would like to double click the quote number or the record on the subform and have the main form display this data and requery the subform. The Main form could even close and reopen if necessary. Please Help. I have many situations where this technology would come in handy. I have a lookup customer button on a form that could use this technology to populate the form once the customer was chosenb from the list. I have also tried doing this with a listbox but that did not work either. Thanks in advance for your help.

Stephen J. Ludwig

 

[JoanneM]

Hi Stephen

for the list/combo box to select a record on your form

put this on your after update property of your combo box and it could help


Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[customerid] = " & Str(Me![cmboCustomers])
Me.Bookmark = rs.Bookmark


Where cmbocustomers is the name of the combo box on your form

Re the other prob of synchronising on orderid
Northwinds did that I believe using 2 subforms - check it out it may be pertinent.


regards


jo