Add a date

[jenncivello]

Hi there,

I have a training table I have setup, with group numbers and dates. I would like to be able to type the group number and then it automatically puts in the date in the next field. E.g. Group 1 Feb 8/12. Can you please tell me if this is possible and how to do it. I am a basic access user.


Thanks

[sstrauss87]

The dates are already in the DB? Or you want it to fill in the date with the day it was entered?

[sstrauss87]

Do an after update event for your group Id
Date = DLookup("GroupDate", "dbo.TableName", "GroupID = Me.GroupID")

Hope this helps

[jenncivello]

The dates are already in the DB as a seperate field. and the groups are in another field.

[sstrauss87]

So use the DLookup after you enter the group ID

[jenncivello]

is this done in the tabe or query?

[sstrauss87]

Visual Basic

[sstrauss87]

You should prob do this through a form if your not already, are you trying to create a schedule?

[jenncivello]

ok. yes i am. but i am a basic access user

[sstrauss87]

Well I would create a form that inserts data into table then write vb code to auto fill data. do you only have 2 fields?

[jenncivello]

Hi There, Is there an easy way to do this? I am having alot of trouble trying to figue this out. I have a table with my dates and then another table with my users and the training date. But everytme there is a change i have to change the group and date. I would like to be able to just change the group and the date automatically update.

[sstrauss87]

well are the date changes always consistent?

[jenncivello]

yes, they are every wednesday

[sstrauss87]

If the dates are randomly chosen by you there is no way the db can tell what to enter for the group date.