I have a forn with a textbox whose control source is dlookup...

When I open the form the control does not show any data. However, when I
click on the control the data is displayed.

Any ideas on how to make the data display when the form opens?

Thanks.

If the DLookup() expression depends on other controls on the form, chances
are that those values are not present early enough.

Use ReCalc to force the calculated expressions to update.

Either that, or get the data for the expression from somewhere independent
of the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"SAC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a forn with a textbox whose control source is dlookup...
>
> When I open the form the control does not show any data. However, when I
> click on the control the data is displayed.
>
> Any ideas on how to make the data display when the form opens?
>
> Thanks.

I'm not sure where to put the recalc. I put it in the on_current event as
me.recalc. I see the valuse briefly in the control then it goes blank.

Where can I put it so it'll work.

Thanks, Allen.

"Allen Browne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If the DLookup() expression depends on other controls on the form, chances
> are that those values are not present early enough.
>
> Use ReCalc to force the calculated expressions to update.
>
> Either that, or get the data for the expression from somewhere independent
> of the form.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "SAC" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I have a forn with a textbox whose control source is dlookup...
>>
>> When I open the form the control does not show any data. However, when I
>> click on the control the data is displayed.
>>
>> Any ideas on how to make the data display when the form opens?
>>
>> Thanks.
>

Agreed: Form_Current's not really a good idea. Form_Open and Form_Load are
probably too early, and Form_Activate is not good either.

Perhaps you could use an unbound text box, and assign it a value in
Form_Current.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"SAC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm not sure where to put the recalc. I put it in the on_current event as
> me.recalc. I see the valuse briefly in the control then it goes blank.
>
> Where can I put it so it'll work.
>
> Thanks, Allen.
>
> "Allen Browne" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> If the DLookup() expression depends on other controls on the form,
>> chances are that those values are not present early enough.
>>
>> Use ReCalc to force the calculated expressions to update.
>>
>> Either that, or get the data for the expression from somewhere
>> independent of the form.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>>
>> "SAC" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have a forn with a textbox whose control source is dlookup...
>>>
>>> When I open the form the control does not show any data. However, when
>>> I click on the control the data is displayed.
>>>
>>> Any ideas on how to make the data display when the form opens?
>>>
>>> Thanks.
>>
>

Excellent! I put the dlookup in the data source query. Works fine EXCEPT
the format.

The control on the form is formatted for Currency, but I'm getting several
decimal places. I changed the format for the column in the query and I'm
still getting the same result.

How can I fix this?

Thanks, again.

"Allen Browne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If the DLookup() expression depends on other controls on the form, chances
> are that those values are not present early enough.
>
> Use ReCalc to force the calculated expressions to update.
>
> Either that, or get the data for the expression from somewhere independent
> of the form.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "SAC" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I have a forn with a textbox whose control source is dlookup...
>>
>> When I open the form the control does not show any data. However, when I
>> click on the control the data is displayed.
>>
>> Any ideas on how to make the data display when the form opens?
>>
>> Thanks.
>

Never Nind. I got the formatting. I just used the format function in the
coloumn in the query and it works great.

Thanks for your help.

"SAC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Excellent! I put the dlookup in the data source query. Works fine EXCEPT
> the format.
>
> The control on the form is formatted for Currency, but I'm getting several
> decimal places. I changed the format for the column in the query and I'm
> still getting the same result.
>
> How can I fix this?
>
> Thanks, again.
>
> "Allen Browne" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> If the DLookup() expression depends on other controls on the form,
>> chances are that those values are not present early enough.
>>
>> Use ReCalc to force the calculated expressions to update.
>>
>> Either that, or get the data for the expression from somewhere
>> independent of the form.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>>
>> "SAC" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have a forn with a textbox whose control source is dlookup...
>>>
>>> When I open the form the control does not show any data. However, when
>>> I click on the control the data is displayed.
>>>
>>> Any ideas on how to make the data display when the form opens?
>>>
>>> Thanks.
>>
>