Default value of combo box based on DLookUp

[Bob Wickham]

Hi,
I have 2 problems I'm trying to overcome regarding just one form which gets
its data from 1 table.

I'm trying to set the default value of a combo box to be the same as another
combo box on the same form.
The scenario is:
I have a form for entering info about financial planning Statements Of
Advice.
Each client has a Plan Writer prepare their plan.
To find the plan writer that last prepared the plan for a client I have a
combo box with a DLookUp as its Control Source.
=DLookUp("Plan_Writer","qryDefault_Planwriter","[Client]=Form![Client]")

I'm using a query so as to find the most recent record for a client.

Works wonderfully! but this combo can only be used for display.

Now the part thats causing me grief.

I want the value returned by that DLookUp to be the default value for
another combo box with the Row Source of
SELECT tblPlanWriter.Plan_Writer_ID, tblPlanWriter.Plan_Writer FROM
tblPlanWriter;

The second combo must remain editable so that another plan writer can be
chosen if necessary

I've played around with all sorts of things, using the Expression Builder,
borrowing bits of code from all over the net, Before Update, After Update.

I cant find anything on the internet the same as what I'm attempting, which
makes me wonder if what I want is even possible.

The second problem I'm having seems much easier but I've had no success.
I want one date text box to default to be 14 days later than another date
text box.
I have [Date_Received] and [Date_Due]
I've tried making the default value of [Date_Due] to be [Date_Received] and
it works.
[Date_Received] + 14 does not.

I'd love some assistance with either or both of these problems.

Thankyou

Bob

 

[Pieter Wijnen]

Probably not the whole solution, but place an equals sign in front of the
default value (as with the controlsource)

Pieter

 

[Bob Wickham]

Thanks Pieter, but I've tried that.
Do you think I'm on the right track or do I need to really re-think the
whole design.

Bob


"Pieter Wijnen"

Probably not the whole solution, but place an equals sign in front of the
default value (as with the controlsource)

Pieter

Hi,
I have 2 problems I'm trying to overcome regarding just one form which
gets its data from 1 table.

I'm trying to set the default value of a combo box to be the same as
another combo box on the same form.
The scenario is:
I have a form for entering info about financial planning Statements Of
Advice.
Each client has a Plan Writer prepare their plan.
To find the plan writer that last prepared the plan for a client I have a
combo box with a DLookUp as its Control Source.
=DLookUp("Plan_Writer","qryDefault_Planwriter","[Client]=Form![Client]")

I'm using a query so as to find the most recent record for a client.

Works wonderfully! but this combo can only be used for display.

Now the part thats causing me grief.

I want the value returned by that DLookUp to be the default value for
another combo box with the Row Source of
SELECT tblPlanWriter.Plan_Writer_ID, tblPlanWriter.Plan_Writer FROM
tblPlanWriter;

The second combo must remain editable so that another plan writer can be
chosen if necessary

I've played around with all sorts of things, using the Expression
Builder, borrowing bits of code from all over the net, Before Update,
After Update.

I cant find anything on the internet the same as what I'm attempting,
which makes me wonder if what I want is even possible.

The second problem I'm having seems much easier but I've had no success.
I want one date text box to default to be 14 days later than another date
text box.
I have [Date_Received] and [Date_Due]
I've tried making the default value of [Date_Due] to be [Date_Received]
and it works.
[Date_Received] + 14 does not.

I'd love some assistance with either or both of these problems.

Thankyou

Bob