Auto populate date field in payment table

[jeffrey.ccs]

Hi

I am new to Access and have started to move across some Excel based programs.

I have a simple example with two tables and a form where on the form a customer ID is entered which displays the name and below it is necessary to enter the total payments made by that customer for the day ( all records for the same day are entered at one time, which is why I would like to autofill the date). I can enter the date directly on the form for each customer entry but I would like to automatically enter the required date in the payment table using the value of a datepicker on the form to ensure that no date errors are made.

I have been trying to use the expression builder to do this but the datepicker does not seem to appear as a valid option.



Any advice would be warmly welcomed.

Regards

Jeff

[pbaldy]

I wouldn't use an ActiveX control. If you just add a textbox bound to the date field, you should automatically get a date picker in 2007/2010. If you want today's date, you can use Date() in the default value.

[jeffrey.ccs]

Hi

Thanks for your reply.

I can show the date field from the payment table on the form and have a picker but with up to 300 entries daily I would like to pick the date once and have it populate the payment date field automatically and thus minimize the amount of manual entry. It is that part that I can not find how to achieve, it seems that it should be straightforward but I tried using expression builder to use the change event in the datepicker and could not get it to update.

Regards

Jeff

[pbaldy]

You can try this in the after update event of the date control.

http://access.mvps.org/access/forms/frm0012.htm

[jeffrey.ccs]

Hi

Thanks a lot I will go and try it out.

Regards

Jeff