Recent content by GinaWhipp

Hmm, do you have a Set Focus anywhere behind that Form? Also, you did put it in the KeyUp event not the OnChange event right? The code I provided will fail in the OnChange event. EDIT: Stepping away for a bit, dinner and a movie. Will check for replies when I return.

Did you completely remove the On_Change event? You cannot Set Focus to the Control.

Hmm, give this a try. In the KeyUp event procedure of the Combo Box (might need some tweaking)... If Len(Me.Combo0.Text) >= 2 Then 'Set the row source to match user search criteria Me.Combo0.RowSource = "SELECT taglio.[num taglio], taglio.[cod modello], taglio.Quantita...

I took a peek.

You are updating (subtracting) the parts the tblMainItemParts table from tblInventory. Though in your case you might be adding to your Transaction table to be subtracted from tblInventory. Can't say for sure how you add\subtract parts from your tblInventory without seeing it. You need to do...

Not individual tables for each item, so... tblMainItem - wagon tblMainItemParts - linked to tblMainItem includes all the parts and there quantities linked from the inventory table. Then on the BOM you would use the ID from tblMainItem and run a query to UPDATE the Inventory table.

Do you have a tables that hold the four items and the parts they need?

Wouldn't the completed item go on the BOL? Oh, I see @arnelgp has posted a document. See if that helps as I would not be assembling the finished goods on the BOL that is where the completed item gets shipped.

What new data? If it's a simple look-up from the drop down why aren't you showing it in the combo box instead of the ID? Or you could just show the specific column from your combo box in the text control. What am I missing?

Ah, glad to know you are not starting from scratch. Well, not sure this will work for you but this is what I do. In the Inventory table there are two additional fields: iBillOfLadingID and iStatusID (it's shipping status). When the inventory items gets added to the Bill of Lading but has not...

Welcome to the Forum! Hmm, You're new to Access and you are developing a small database for inventory, bill of materials, work order, purchase orders with all the other pieces and parts necessary AND you want suggestions. How new are you? This is relatively a hard business model for your...

Well, linking your subform on Weekday so you're right that won't work. Since you are showing all the Students why are you linking those Forms? That said, if you want to store which Students attended sounds like you are going to need an update query. Also, the Sessions subform should not be on...

So the Staff log on and see there Sessions? If so then why not show the Students attending that Sessions? Or do you just want to who all the Students?

Hmm, not getting it. Do students sign up for these classes? Because it seem to me you pick the Staff Member and then the Session which should then show the Students signed up for that Session. You can then enter the date and check off those that are present.

I think what you are looking for is a Loop. Have a look at... https://www.access-diva.com/vba3.html