Recent content by asteropi

forgot to take it off. it's fixed now thank you

I actually don't save all the details in the Batch tables. It's just for my reference in the form, but I only save ProductDetailsID and SupplyID

Exactly to the point

if it looks it up and for whatever reason I change suppliers, then the old batches will also channge suppliers, which I can't have. I need it to record the info in the batch table

I realized I needed to record the lot and supplier in the BatchT for historical records. So I made 2 fields there and had the command button add my info in that table instead Now I need to figure out how it will not input all the lots of one ingredient in the report This is the correct one

Never mind all. I fixed it myself.

I order supplies which have lot numbers, make the products which have batch numbers and sell to customers When I make the batches I have to record which lots I used from the product, so if I get a bad one and the manufacturer recalls it I will know where I used it. So I need to history record...

I fixed them I think

I do not know et to work with relationshiops And indeed it should be ProductDetailsID in both tables

I took off all the fields from those tables that I had in the query and now the VBA suppowedly works I made unbound boxes and it takes the info However, let's say I use IngrA and IngrB WheI put IngrA it takes SupplierA and LotA But when I put IngrB, the SupplierA changes to SupplierB and LotA...

I did that but the VBA then gets stuck at the Me.Refresh command lol lol. I don't know why

When making a batch it is important to record from which manufacturer you got the ingredient as well as which lot you used. So I need to have them on the form

Hey all, Once again I turn to you for assistance. I have a problem I do not understand I have a form to record batches of products made. The indgredients I get from a drop down menu. Menu has the supply name-colour-manufacturer-lotnumber When I get the ingredient, it seems it gets the name from...

Fixed thank you