Return Query Value to Form Field

  • Thread starter Thread starter NeoFLeX
  • Start date Start date
N

NeoFLeX

Greetings:

I have a select query (Called queryPhones) that returns a single
result, with a single column called queryPhoneNumber. I want to be able
to set the default value of a Form field to the value returned by the
query. I'm using the code:

Forms!testConfirm!testPhone.DefaultValue = """" &
[queryPhones]![queryPhoneNumber] & """"

The query will only ever return one result.

NeoFLeX
neoflex at gmail dot com
 
Try:

Forms!testConfirm!testPhone.DefaultValue =
DFirst("[queryPhoneNumber]","queryPhones")

HTH,
Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy record info into new form 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Form based query wont return all values 6
Main Form and two Subforms 2
Enter Table/Query value in Form 2
I need a Form button to open and pass two variable values to a re 2
query value subform 3
copy value to form 1

Back
Top