Search results

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

Ok I fixed this problem but now there is another one Even though it takes all the data I input, if I close and reopen the form, the Batch Details don't show, even though they are saved in the table

That was also a leftover which I deleted now. I also allowed the data entry but I still get the same error as before I fixed all the controls and deleted any leftover commands that didn't make sense and compiled the database

I don't know what you mean or how to fix that

I don't know how to change the form name to compile this part

I deleted that. I had accidentally left it there