Continuous Form

[Doua]

I'm hoping that someone in here can assist me. It might
just be an easy code that I need. I have no experience
with VBA.

Here is what I am trying to do. I'm trying to create a
schuduling form for programs which have deliverables. I
have a table for the programs, deliverables, and schedule
date. A program can have many deliverables.

I created a continuous form for the deliverables for the
programs. The programs and deliverable fields are bound
fields link to a query and the start date and finish date
are unbound.

Program A has 5 deliverables, lets said deliverable 1 -
5. When I open up the form I am able to see all this 5
deliverables on the form and able to enter in dates for
the deliverables and click a command button to save them
to the schedule table. My program is, when I entered a
date for the unbound StartDate and FinishDate for
Deliverable 1 it automatically filled in for the other
fours deliverables with the same date. I want to be able
to schedule them individually with a different date. How
can I do this?

I appreciated any helps that I can get.

TIA.


Doua

 

[John Vinson]

My program is, when I entered a
date for the unbound StartDate and FinishDate for
Deliverable 1 it automatically filled in for the other
fours deliverables with the same date. I want to be able
to schedule them individually with a different date. How
can I do this?

An unbound control is just that - a "scratchpad" on the screen. The
data in an unbound control is not stored anywhere, nor is it related
to any particular record in your table.

If you want a particular deliverable to have its own date fields, then
you must include date fields in the Deliverables table and use bound
controls on the form to update those fields in the table.