Transfering data from one form to another, but also using criteria

[GoinDeep]

I want to transfer data from a field on one form to a field on another. I assume I would use the following to transfer:

ItemID_AfterUpdate:
Me.ItemCharge = Forms!PriceList.ItemCharge

But here is where I am having the problem. PriceList is a continuous form that has ItemID and ItemCharge. So I need to transfer the ItemCharge where the ItemId's match. I was thinking something like this, but appear to be way off:

ItemID_AfterUpdate:
Me.ItemCharge = Forms!PriceList.ItemCharge WHERE "[ItemID]=" & Me![ItemID]

I know WHERE is not the right thing to use, but that is the only way I could explain what I want to accomplish. I hope I made it clear and can get some help on this. Thank you.

 

[lameid]

You could perform a find on your continuous form by setting the focus to the field first and then using FindRecord to navigate to it.

Personally, I would skip all that and use DLOOKUP to get the value you want directly from the table.

Me.ItemCharge = Dlookup("ItemCharge","PriceList", "[ItemID]=" & Me![ItemID])

The above assumes PriceList is the name of the query or table that contains the value you wish to lookup.

 

[KenReay]

Hi

See you post on same subject in "Other topics" forum, tested solution there Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK