Reply to thread

Message: [QUOTE="Bob Wickham, post: 10837727"] 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 [/QUOTE]

Verification