Here's what I have
A form
A query
A table
The table is where information needs to be stored into (named "Security Master") and it has text boxes to store that data in.
The form "Make Symbols" is what the user opens up and adds data. This form has three controls and a text box. The three controls are drop down boxes where a user will select something from. The text box is where the user will enter a quantity into. A total of four things must be entered.
Note: Those four things are what it takes to generate 6 alpha-numeric symbols.
I have query with those 4 things in it from the "Make Symbols" form along with 6 more text boxes where I have code in it to take that data and arrange it into the alpha numeric symbols. The code works! Thanks to Bytes.
The intentions are once the user enters that data, they click an "enter" button and that data writes to the table "Security Master". Including the 6 special alpha-numeric symbols.
This table of data is what I will use to run various reports on request and/or export to Excel for other users to do whatever it is they do with it.
It's probably simple, right? I just can't figure it out.
Suggestions??
A form
A query
A table
The table is where information needs to be stored into (named "Security Master") and it has text boxes to store that data in.
The form "Make Symbols" is what the user opens up and adds data. This form has three controls and a text box. The three controls are drop down boxes where a user will select something from. The text box is where the user will enter a quantity into. A total of four things must be entered.
Note: Those four things are what it takes to generate 6 alpha-numeric symbols.
I have query with those 4 things in it from the "Make Symbols" form along with 6 more text boxes where I have code in it to take that data and arrange it into the alpha numeric symbols. The code works! Thanks to Bytes.
The intentions are once the user enters that data, they click an "enter" button and that data writes to the table "Security Master". Including the 6 special alpha-numeric symbols.
This table of data is what I will use to run various reports on request and/or export to Excel for other users to do whatever it is they do with it.
It's probably simple, right? I just can't figure it out.
Suggestions??