Transfer data from form to another form
Thank you for taking the time to report an issue.
What's wrong... Please write below.
How can I capture data input from a scanner without displaying it into an actual text box. If a barcode with certain text in it is scanned, I want the form to transfer control to another form for further processing.
Or, must I enter the text into a hidden field for the purposes of capturing the data first and then using the Timer Event ot process it? I use the Form_KeyPress Event to see if that would capture the data input, but it does not do that. What event would capture data input from a barcode device without having to display it on a form?
I have a feeling it's by using macros but I'm unsure.
If it is would it simply be the case of recording the copy and paste of data from the form to the table?
How can I do this?
The quote form allows the user to add valves and balancing (two more products) to the quote. The quantity of these is usually, but not always the same as the 'main' product (tyre), and equally the price is variable.
Once accepted I need to transfer the figures on the quote form to my Quote and Quote Details tables. I can do this for the tyre, but how can I get the valves and balancing products alsoadded? In short, I need to add three records to my tables on the click of a button.
I want to be able to double click the data in the 2nd form and copy that data into the field on the original sub-form.
I.e. Form 1 has sub-form 2, with field 3. Double-clicking field 3 opens Form 2. I want to double click a field in Form 2, and place it in Form 1-sub-form 2, field 3.
The sub-form name remains static, but Form 1 would vary.
I am hung up on how to get the login information to transfer over to the form. Here is the code that controls the login process;
All I need is the username. And then I need it to autopopulate a field in a form.
When I select the data from the 3 combo boxes in the main form and close the form without entering data in any of the fields in the sub form, these 3 fields are getting saved in the table associated with the sub form.
I don't want that. If data is entered in at least one of the controls in the sub form, the data in the 3 fields of the main form along with the data in the sub form should be saved in the table. How do I accomplish this?