Display LIKE values in Unbound Link Box on entering values in Text Box in Form

[June7]

Don't think writing code to build form or report will really be very helpful in understanding how things work.



Creative solution for the cascading combobox. Can't recall ever seeing it or having thought of it.

Instead of building a query object for combobox RowSource, I would put the SQL statement directly in the property.
SELECT ProdID_PK, ProdName FROM tblProducts WHERE IndID_FK=[cboIndID] ORDER BY ProdName;

[recyan]

Creative solution for the cascading combobox. Can't recall ever seeing it or having thought of it.

Got it from here ( ContinuousCombo.zip )

http://www.databasedevelopment.co.uk/examples.htm

via

http://www.access-programmers.co.uk/...d.php?t=189741

Thanks

[recyan]

Am attaching TestDB_1 as an example ( Still fiddling around with combo boxes with my friend Google ).
1) When I enter a New Customer Record, why does the Industry & Product display the previous Entered Values for the Previous Record.
2) Why does tabbing not work ?
Perhaps cannot be accomplished or just a matter of a few tweaks ?

Thanks

1) Managed to solve it by putting the query for cboInd in the On Current event of the Form.

2) Still breaking my head with this.

Thanks

[June7]

Change the TabIndex property of the controls to: 0, 1, 2

[recyan]

Thanks June.
That works fine.

Thanks