How to bind a text box on a form to a specific field?????

[fargo]

Maybe I'm doing it all wrong but here goes.

I want to pull a value from one field on a query that contains only one record, so that I can then use it in a calculation and I dont seem to be able to correctly do it.

Can anyone help.

Thanks

 

[ntp]

you could use DLookup to get the value.
Example, me.txtFieldValue = Dlookup
For a string value
("[FieldName]", "queryName", "[SomeField] ='" & Somevalue & "'&quot
For a numerical value
("[FieldName]", "queryName", "[SomeField] =" & Somevalue)

This assumes you know the value of some field from the query already.

ntp

 

[rafe]

Try using the domain aggregate functions instead. They’re actually mini-queries that you use as a control's data source.

As an example, if I wanted to get may last name from the Personnel table via my Nickname I’d set the TextBox's ControlSource to...

=DFirst("[LastName]","Personnel","[NickName]='Rafe'&quot

You can also use domain aggregate functions in equations like…

=DSum("[Amount]","Payments","[Type]=30&quot-1000000

These are just random samples & I could help with your particular TextBox if you post specifics

WARNING: Over use of domain aggregate function can *really* slow up the system. I just use them in onesies & twosies more than that & I rethink the design.

 

[fargo]

Thanks rafe and ntp for your answers, I am still missing something though.

The text box on my form called 'frmCeilings' is named 'txtMainTcost' and I want to put in the value held in the field named
'Cost per Metre' from the Query named 'MainTeesQ'

I have been trying to do this as per your advice for example

=DLookUp("[Cost per Metre]","MainTeesQ","[txtMainTcost] =" & [txtMainTcost])

but I must be doing something wrong as it is not working.

Thanks

 

[ntp]

=DLookUp("[Cost per Metre]","MainTeesQ","[txtMainTcost] =" & [txtMainTcost])

This is wrong. the lookup function is used like this:

Dlookup(field1, table, field2 = value)

field1 - the field whose value you want to return
table - the name of the table/query the field belongs to
field2 - the name of a field whose value you know, e.g a ID field
value - the value of field2 that you know

So your code should be

me.txtMainTCost = DLookUp("[Cost Pre Metre]", "MainTeesQ", "[MianTeesQID] =" & IDValue)

This assumes that MinaTeesQID is the primary key from MainTeesQ and IDValue is the value of the record whoose [Cost Per Metre] you want.

Hope this clears things up.

ntp

 

[rafe]

also remember those single quotes surrounding text fields that were in ntp's original post. so if [txtMainTcost] is a text field you would change your line to the following...

=DLookUp("[Cost per Metre]","MainTeesQ","[txtMainTcost] ='" & IDValue & "'&quot