Search results

Does this look right? I have this on current event on NightCountEnterReturnsSubform Private Sub Form_Current() Forms!NightCount.NightCountInventorySubform.Form.SetFocus DoCmd.FindRecord Me.InventoryID End Sub When the form loads it gives an error, debug and hover over setfocus line which is...

Good to know! I'll try this if I can't get record find to work, which of course at this point is giving me an error. :) Thank-you! Someone understands. I am actually storing the barsreturned though, that was just so I could have a spot for each record. To me not a big deal, its never recalled in...

I'll see what I can do with that, I'm just googling it as well. I know this might not be proper but if it works what makes it not proper? :) So far I think its great, someone can enter how many returned and it figures out how many were sold, writes that number to the table and all my queries...

A lot of my MasterLinks are in another subform and I haven't had trouble yet, they all link the way I expect them to. Maybe its because I'm linking in the order I'm putting a new subform on the mainform. Anyways if I put a textbox on the main form and refer to the controlsource "InventoryID"...

yeah that's what its doing from the current record, if I select another record because it becomes current it uses that number. The subform is showing only the records I need it to, it can't show any less. There must be a way that when I select record #3 in the outline subform it also sets...

That's cool, I've been playing lots with that thinking it had something do with it and thought it would be nice if 2 things could go there but didn't think it was possible, I'm a newbie of course. I tried a few different 2nd links but couldn't get any different results. What would I use as the...

sorry that makes no sense to me, I read it 50 times. :)

So close I can feel it. I just discovered that on the subform with "given" column if I select the 2nd record it will use the number in that record, if I select the 3rd record it will use that number. Now I need to figure out when I select a record in the outlined subform the same record gets...

I'm getting closer, if I use the code below it works but on the subform with the column "Given" it takes the first record, 33, and uses that for all the records on the outline subform where I'm enter the returns. Me!BarsSold = Forms!NightCount!NightCountInventorySubform.Form!BarsLeft -...

Do I want to refer to a control or record source? I've tried all the control ones and nothing works.

Thanks for the quick replies, I'm going over that page and will try some. I know its not good to store calculations but this is a special case. The db was originally designed so at the end of the night a person would enter barssold so all the queries, forms and reports use the field barssold...

I have a form which I need to do a calculation on a field and have it write the answer to the table. I can do it if everything is on the same form or subform using Me.BarsSold = Me.BarsLeft - Me.BarsReturned. But I can't do it when there on different subforms. I took a snapshot of the form and...

Does that update query force a query to be updateable? Is that what that's about? I've not used any query type but select. If I make the same query I have made as a select query as an update query will I be able to update it? As a select query I can't update it and thats the problem. If an...

Open the form "night count" and you will see where I need the math done.

lol yeah its a little confusing. tblInventory = product tblorders = orders tblordersdetail = inventory (this is the order details, its actually details for transfers and purchases) tblvendors = vendors suppliers is there in case he wants to track who he purchases from at a later date...

The db is inventory control, its for the ice cream industry. We need to track inventory by vendor, cooler, vehicle and trailer, its kinda complicated but all works great. I wish I knew from the beginning it would have been based on bars returned instead of bars sold that's really screwed things...

Hi, are you sure my tables are wrong, I know there worded wrong. I have a table called product, which is all the product, then orders which holds all the orders and then inventory which is all the product that goes on an order or purchase or transfer, isn't that the way to do it. Inventory is...

Yeah I do need the values to be copied over. Maybe you can help me string this line together, I've tried a lot of different strings for the one subform but can't recall the record. But first I will explain how it all works. The form is for items returned at the end of the night. When a new...

unfortuantely that doesn't really make sense to me, wuold it be easier to have all the records in the subform values turn to 0 when opens. There will be a value in barsreturned already but when I open a subform it would be nice if all those numbers went to zero. Does that make sense?

Hi, I have a form that has 3 subforms, one subform is linked to the main form and the other 2 subforms are linked to that subform. The 2 subforms that are linked to the same subform and bring up the same data and have the same amount of rows or records, these subforms are set to continious...