valeryk2000
Registered User.
- Local time
- Today, 05:51
- Joined
- Apr 7, 2009
- Messages
- 157
Hi everybody!
I have a SQL Server database and preexisting Access forms (all tables and queries were exported to SQL Server). Access forms contain subforms. I linked controls on the subform to a local table that populates subform from recordset created from SQL Server stored procedure that accepts a parameter (ID) and returns records related to this ID. No problems when I have textbox(es) in the subform.
Tricky part (for me) begins when a subform contains a combobox and a textbox. On form_load I populate the combobox. User selects an item from combobox, types details in the textbox and repeats these steps as many times as necessary. Once local table is populated the data can be saved to SQL Server tables. However when I want to retrieve the data FROM Sql Server tables I have to set a value in combobox that corresponds to this record and still keep the combobox items (that were populated on form_load event) intact so the user can use it creating next record(s). Any idea how?
I have a SQL Server database and preexisting Access forms (all tables and queries were exported to SQL Server). Access forms contain subforms. I linked controls on the subform to a local table that populates subform from recordset created from SQL Server stored procedure that accepts a parameter (ID) and returns records related to this ID. No problems when I have textbox(es) in the subform.
Tricky part (for me) begins when a subform contains a combobox and a textbox. On form_load I populate the combobox. User selects an item from combobox, types details in the textbox and repeats these steps as many times as necessary. Once local table is populated the data can be saved to SQL Server tables. However when I want to retrieve the data FROM Sql Server tables I have to set a value in combobox that corresponds to this record and still keep the combobox items (that were populated on form_load event) intact so the user can use it creating next record(s). Any idea how?
