Search results

[prid] is the primary key of the item I wisk to store. The default value for [prl] is set to =[Forms]![3frmSites]![3frmPProductSub]![Form]![prid] and is where I wish to store it

Thanks Bob as always, but =[Forms]![3frmSites]![3frmPProductSubsub]![Form]![prid] is till not working for me - I'm baffled by the behaviour of this. As i said it worked once before, but not now

At the risk of sounding ungrateful, any ideas why [Forms]![3frmSites]![3frmPProductSubsub].[Forms]![prid] didn't work?

Thanks very much for that, but 1st attempt not successful and I'm decidedly dodgy in using the VBA - the example shown there leaves me confused as to what I need to add and what to leave out

I have a form with a (continuous) subform - against each item in the subform I have a control button to open a pop up form related to that record. All works well except the foreign key in the pop up is not being populated. I have had this problem before and was solved by setting the default...

Or on the other hand, to quote the great Rampaging Roy Slaven Too old, Too slow, Too stupid !!!!!

I think this has finally exposed (if loosing twice in England hadn't already) Ponting's captaincy - He is not very good strategically and with age, his batting is going off. For me, Mark Taylor was a much better captain, and even when he had a form slump, the team still played well and win...

Yeah, i jumped the gun a bit there and I see jzwp22 has given a good solution

Create a query of Active employees and use that to populate the combo box instead of the employees table

You would have thought he would posted some samples for us as an inducement

You have caught me at a very bad time (see Watercooler/The Ashes and you will understand) also, in NOT keeping with the theme, I have had too much Aus premium wine -not cocktails.... At the back of my mind, update queries don't work when Group By are involved - Append do (ask Bill Gates why...

Hey, did you think we would not go out sledging all the way?

After day 2..... and bowing to the inevitable, one must pay credit to South Africa B for retaining the Ashes

Then take 2 asparins and call me in the morning....or better still, given the nature of the project, a few stiff drinks

Added some new queries to a calculate usage and update stock - essentially it is a 'Group by Sum' and then Update query to adjust stock

After day 1...Perth, apparently didn't happen and normal services have now been resumed

Well, if you're going to resort to flattery, I'll take my business elsewhere !! Good luck

OK, have added a Stock table & added to the Cocktails table - you would then need to build a query to calculate the amount of Drinks sold and reduce the amount of stock by that amount

Something along these lines I think

I was just thinking, before spending too much time adding data to ensure that the structure is right from the beginning