open form based on combobox
Thank you for taking the time to report an issue.
What's wrong... Please write below.
So far I have combobox with.
SELECT tblLoad.LoadID, tblLoad.LoadDate, tblLoad.AutoclaveID, tblLoad.LoadNumber, tblLoad.[Cycle Complete] FROM tblLoad WHERE (((tblLoad.[Cycle Complete])=0));
Bound Column is 1
This works to limit records shown in combbox.yea!
Now I can't figure out how to open form to that particular record.have tried several things in afterupdate of combobox.but no luck
if the combobox is empty, then the button will open a form and start a new record
if the combobox has a value in it, then the button will open a form to the correct record (corrosponding to the combobox value)
the form that the button opens modifies the table that the combobox data
is picked from.
all of this works as expected. now for the question :
when the user returns to the original form, how do I get the combobox to 'update' the available values from the table that the other form just modified? ( I prefer to not do this as I close the other form, but rather put some code in to update the combobox when the original form regains focus ) for example, if the user creates a new record, and then closes the form, the combobox does not have the new record as a choice.
on event gainfocus : me.mycombobox.rebuild your list
But then I can't use my combobox for changing to onother post in frmUnit because the frmUnit is locked to just MyID = 45 even if I can change the value in my combobox.
How to release the frmUnit combobox not changing the one and only MyID = 45 showed post ?
My problem with this comes when I press the button and I get a message box titled "Enter Parameter Value" with my field reference line Forms!subFrmName!cboName with a text box underneath.
Am I doing something wrong? I've checked the subform name and combobox name multiple times and it appears that I'm referencing them correctly.
I have the form built and here is the code behind the cmd button set OnClick:
1) Products Category
1. Select the category from the first combobox,
If the category is not available update the category table by enterting the category in the combobox
2. Based on the selection of the category combobox the products will be displayed in the products combobox.
Again if the product is not available update the products table
3. Based on the products combobox the packing will be displayed in the third combobox.
I was able to get the data in the second combobox based on the selection in the first combobox. But not going to the third one. Also to add a new item if not available.
So I want to be able to type in a sales order number on a form and have it populate a combobox on that form with the serial numbers attached toit.
I have read numerous topics on this site relating to this topic and I have tried all the responses but I just keeping getting lost in the middle of the
They are used for tracking any system changes. I create a new record and have a combobox to select which user made the change. The form contains an editable side for new record entry and a locked side to show the verify info.
This updates the tbl_systemEdits.
I have a query based on this table that only shows if a verified date is null. The Verify Open Records is based on this query so that a different user can verify the edits. I have a combobox on the verify section to select a user, which should populate back to the New Record form but all I can get it to list is the Record ID, not the user name