lionne
12-28-2011, 01:51 AM
Hi everybody,
I've got an issue, that makes me unable to sleep at night, because I can't solve it.. tried many things, but nothing worked...
I have a list of some parameters (TextBox Names), based on which I generate the Excel Form (UserForm1) for a user to fill it out.
If I have a parameter (TextBox Name) in the list called say "asset", then I add a button to the UserForm1, which is called "Find Asset". By clicking on that button, new Form UserForm2 is opened, where I have 3 ComboBoxes - search criteria. Then, by pressing OK, my DB Query looks for an asset. If the value is found, I need to transfer it to a UserForm1.asset TextBox. Exactly this step I don't know how to do. This doesn't work:
UserForm1.asset.Value = rs(0).Value 'rs is a RecordSet
Is it possible to give the rs(0).Value to a TextBox field of UserForm1 at all?
Lionne
I've got an issue, that makes me unable to sleep at night, because I can't solve it.. tried many things, but nothing worked...
I have a list of some parameters (TextBox Names), based on which I generate the Excel Form (UserForm1) for a user to fill it out.
If I have a parameter (TextBox Name) in the list called say "asset", then I add a button to the UserForm1, which is called "Find Asset". By clicking on that button, new Form UserForm2 is opened, where I have 3 ComboBoxes - search criteria. Then, by pressing OK, my DB Query looks for an asset. If the value is found, I need to transfer it to a UserForm1.asset TextBox. Exactly this step I don't know how to do. This doesn't work:
UserForm1.asset.Value = rs(0).Value 'rs is a RecordSet
Is it possible to give the rs(0).Value to a TextBox field of UserForm1 at all?
Lionne