G
Guest
I have a form showing address records; a subform shows multiple block/lots. Can I make a combo box that will pull up the address record when I enter a block/lot?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Graham R Seach
Sure, in the AfterUpdate event on the control in which you select the
Lot/Block, set the combo's RowSource property to a query that only returns
the records you want. The following page demonstrates how:
http://www.pacificdb.com.au/MVP/Code/ComboRS.htm
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
I enter a block/lot?
Lot/Block, set the combo's RowSource property to a query that only returns
the records you want. The following page demonstrates how:
http://www.pacificdb.com.au/MVP/Code/ComboRS.htm
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
block/lots. Can I make a combo box that will pull up the address record whenrobott said:I have a form showing address records; a subform shows multiple
I enter a block/lot?
G
Guest
Graham: Thanks for the reply. We're on the right track with the example you gave at http://www.pacificdb.com.au/MVP/Code/ComboRS.htm
My two drop-downs will be static - "block" and "lot" from the same table. But then I need the main form to repaint with data from a related table - like a form showing a list of invoices in your example
The event sequence would be: pick drop-down 1, then drop-down 2, then repaint main form.
My two drop-downs will be static - "block" and "lot" from the same table. But then I need the main form to repaint with data from a related table - like a form showing a list of invoices in your example
The event sequence would be: pick drop-down 1, then drop-down 2, then repaint main form.
G
Graham R Seach
In the AfterUpdate event for combo2, just filter the form's RecordSource
property:
Forms!frmMyMainForm.RecordSource = "SELECT * FROM tblMyTable WHERE x =
y"
....or requery the main form:
Forms!frmMyMainForm.Requery
whichever is appropriate in your situation.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
like a form showing a list of invoices in your example.
property:
Forms!frmMyMainForm.RecordSource = "SELECT * FROM tblMyTable WHERE x =
y"
....or requery the main form:
Forms!frmMyMainForm.Requery
whichever is appropriate in your situation.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
you gave at http://www.pacificdb.com.au/MVP/Code/ComboRS.htm.robott said:Graham: Thanks for the reply. We're on the right track with the example
But then I need the main form to repaint with data from a related table -My two drop-downs will be static - "block" and "lot" from the same table.
like a form showing a list of invoices in your example.
repaint main form.The event sequence would be: pick drop-down 1, then drop-down 2, then
G
Guest
The requery after update idea was the key. Thanks much Graham.