DLookUp help please

[drunkwithlust]

Hii.

i have a DVD hire database which has a table two tables included (see below).

The hire tables is for processing a DVD loan and the copy table is the specific copy of a title (for example there could be 5 copies of a film).

I am creating a form that uses the table Hire as a base. The form is just for processing a loan and therefore is just for inputting data. I am trying to set a default value for the field "Hire_fee".

There are three hire bands (band one, two and three). All three bands have a different hiring price associated with them (eg band one=£3, two=£6 and three=£7). The copy number links to the title (In the title table) and the title links to the hire band (in the hire band table).

I am trying to use Dlookup to set this default value however all i have is :
=DLookUp("[Band_Charge]","Hire band","[Hire_Band] = 'Band 1'")
it just returns £3.00 everytime.

Any help would be appreciated as im very new with this. sorry about the length and if you need me to elaborate on anything id be happy to.

 

[lsteffen]

It is returning the 3 each time because rather than setting the default, the DLOOKUP function is setting it to always lookup "Band 1". You can set the default for the field within the table setup itself.

Hope this helps.
Liz

 

[drunkwithlust]

It is returning the 3 each time because rather than setting the default, the DLOOKUP function is setting it to always lookup "Band 1". You can set the default for the field within the table setup itself.

Hope this helps.
Liz

would you be able to point me in the right direction for doing this as i tried to do that also but i didnt know how.
thankyou x

 

[lsteffen]

In design view, there is space in the General tab at the bottom of the window to set the default value for that field. Here is a link to a good resource.

http://www.csus.edu/training/handouts/workshops/Access_2007_Overview_and_Tables.pdf

Hope this helps you.
Liz