dlookup (i think)

[wayney2507]

If you'd like to download the database so you could understand what I'm asking and help me:
http://www.mediafire.com/download.php?zvywan4nrzr

Ok so I have the form "Jobsheet" for the table "Jobsheet".
I want the cost to automatically display if I pick the destination from the drop-down menu (linked to price list table). However, if the destination is not from the dropdown, I could type in a cost there.

I was assuming it would involve DLOOKUP and/or IF formulae.

Thanks for any help you can give.

 

[pbaldy]

I haven't looked at your sample (don't download from unknown sites), but I suspect you want something like this in the after update event of the combo:

Me.CostTextboxName = Me.ComboName.Column(x)

where x is the column containing the cost. That of course assumes you include that column in the combo's rowsource.

 

[wayney2507]

I can assure you that link is safe, mediafire is quite a well known filesharing service and you can see that it's a .db file.

A solution to this is pretty urgently required if anyone can help pls?

 

[Fifty2One]

Your urgent reply was posted by pbaldy - have the source of your combo box two fields - job and cost - then in the after update event put
Me.CostTextboxName = Me.ComboName.Column(1)
you can configure the combo box to accept 'write in answers'.

Mediafire being a trusted file sharing service does not necessarily validate the files stored by their users or guarantee the content of those files. Not to many people will download a file from a user of a forum on their first post.