Need to add dates to form combo boxes

[kwilsokl]

OK
I can’t seem find a way to do this without having to create several date text boxes.

I have a table that has 6 services in it. Medicaid, Medicare, etc. They are combo boxes with predetermined values so the user can select if they are denied, approved etc. Now I need to have a place for them to enter a date when a service is approved. In access you can’t have a filed with the same name so I would need to create a date filed for each service with a name like date1, date 2 etc.

IS there a better way to do this so I can gather a date of when the services started so reports can be gathered in the future?

Any suggestion would be greatly appreciated

Thank you

 

[Pampers]

Not really sure what you mean.... Your layout is something like?

tblApproval
------------
ApprovalID
CustomerID
MedicServiceID
DateApproved

Pampers
Keeping it simple can be complicated

 

[kwilsokl]

No Sorry it is like this

Field name Field name Field name Field name Field name
customerid, medicaid medicare SSI SSD
autonumber Approved notapproved

for the field names there is a combo box where they can select only certain values. approved or not approved.

now I need a date with each field of when they were approved

 

[ProgramError]

Do you want approval dates for each of the fields or one approval date for the whole customer record?

If it's the former then in the afterupdate event in each of the approval comboboxes put...

me.TheNameOfTheApprovalTextBox = now()

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[kwilsokl]

Sad to say it is for each of the fields. If it is not possible I guess I could have them start a new record for each service. I was just wondering how to do this without having several additional records or creating a bunch of date text fields in the table,

Thanks

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886