Dlookup help needed

[krowe]

Hi all

I have been researching this problem for a while now but still cant sort it out despite trying lots of ideas i've found on this site and others.

As background, i'm fairly new to access, only done a couple of basic (really basic!) courses through work, so please treat me like an idiot!

I am trying to create and Income and Expenditure form as part of a DB i'm creating.

I have a table called tblFreq with fields FreqID(autonumber), Frequency(text), Multiplier(number)

the second table called tblIE has fields IEID(autonumber), Rent(number), RentFreq(lookup to Frequency)

I am creating a form to enter the data into called frmIE, based on tblIE. It has the fields Rent(number), RentFreq(lookup). I need a field which returns the Multiplier from tblFreq when I select the RentFreq from the dropdown box.I have created a textbox and entered this, but it won't work: =dlookup("Multiplier", "tblFreq", "forms![frmIE]![RentFreq]=FreqID")

I have tried subsituting FreqID for Frequency but is still wont work.

Please can someone help???

Thanks in advance

 

[pbaldy]

Does this help?

http://www.mvps.org/access/general/gen0018.htm

 

[krowe]

Thanks for your quick response.

I should have said, i have tried this also:

=DLookUp("Multiplier","tblFreq","FreqID = '" & Forms!frmIE!RentFreq & "'")

and get #Error

Thanks again

 

[krowe]

Hi again

I have tried this also: =DLookUp("Multiplier","tblFreq","FreqID = " & [Forms]![frmIE]![RentFreq]) and get #Error

could the problem be something to do with the criteria being a lookup combo box on the form?

 

[pbaldy]

What is the row source of the combo, and what is the bound column?

 

[krowe]

Its ok, I think I have it working now, I recreated it all as I noticed a strange relationship in the tables created by the lookup.

Thanks for your help

Kev

 

[pbaldy]

No problem Kev, and welcome to the site!