Not sure what sort of question this is.

[denileigh]

I have an invoice form that has a subform with line items in it. Each line item has a date field in the table because we partial invoice sometimes. We have a new customer that can have up to 70 line items.

I'd like to somehow auto populate that field with whatever date I type in or by ticking a checkbox or something. Not sure the best way to do that. There are also about 3000 records in it already.

We are running a sql backend on the server and access front end.

Does anyone have ideas/advice?

Thanks so much!

 

[pbaldy]

Is this what you're after?

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

 

[denileigh]

No - they need to all be blank unless I populate them and then it's selected records only. Maybe a check box that if checked automatically throws the date in. I've tried that one but it doesn't seem to save it in the table. Or button that opens a pop-up box that asks for the date I want to use (we backdate also) and fills it in.

 

[pbaldy]

The code behind a checkbox would have to populate a bound textbox for the value to save to the table. So would a button.

 

[denileigh]

Thx! That gives me something to research. I'm a novice at this and sometimes, it's just a matter of knowing what to look-up you know. Thanks again!

 

[pbaldy]

No problem; post back if you get stuck.

 

[denileigh]

Ok - I'm having trouble figuring out how to "bind" it!!! I GIVE UP! *pulls out hair* Help!!

 

[pbaldy]

The textbox Control Source would be the name of a field in the form's Record Source.

 

[highandwild]

I seem to think that your data structure is not designed to support what you are trying to do.

You should have, at minimum, the following:
1. Order Header table.
2. Order Detail table.
3. Invoice Header table
4. Invoice Detail table.

An invoice (single Header record and single or multiple Detail records) are only created when you intend to invoice the customer and can only contain items that are on the order and which have not already been invoiced. There needs to be a check for this.

Creating the invoice detail lines up front and then inputting the date when you intend to invoice is not good practice and will involve more work in the long run.

 

[jdraw]

I agree with highandwild in that your model may not support what you have described.
There is a free datamodel ( link attached) that deals with partial deliveries(shipments) that may be analogous to your partial invoice set up.

http://www.databaseanswers.org/data_models/customers_and_partial_deliveries/index.htm

Good luck.

 

[denileigh]

Is there a way to have click a button and have a pop-up box ask me the invoice date then populate all the fields in the lines with it?? I STILL have not gotten this done.

 

[denileigh]

Would an update query work?