Text box sourced from table needs alternative query source

[njwcad]

Hello

Hope you can help again

I have a text box on a subform whose record source is from the underlying table. I would like to automatically input a value in the text box based on a query. I have tried to set the default value on the underlying table and in the text box property but it doesn't seem to work. I may be missing something obvious but is there any other way to achieve this

Thanks again in advance
Njwcad

 

[Darrylles]

Hi nj,

Heard of the DLookup function?
[tt]
textbox.value = DLookUp("[fieldname]", "tablename", "[EmployeeID] = 7")
[/tt]

Would place the 'fieldname' value into your textbox from 'tablename' where the EmployeeID = 7.

You would have to ensure that there was only ever one value returned.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[Pampers]

Have you tried to set the default value of the textbox itself?

Pampers
Just let it go...