Subform

[ianforest]

Hi folks, i'm a total access noob so please be gentle

I am creating a contract management database, but instead of going into specifics about it, i'll keep what I want to do very simple

I have one table with 20 fields or so, one of which is a date field. When the database is opened, I would like the system to scan this particular date field and if any dates are previous to TODAYS date then one of the other fields in this table is given a different value automatically.

Is this possible?

Secondly, I want to create a form, the top of which is a subform which shows the table data in a grid format. At the bottom of the form is (I guess) a second subform which shows the data in a nicer "tabbed" format for the record selected at the TOP of the form.

Is this possible?

I'm assuming some sort of VBA will be needed here, are there any examples that give me some idea of how to achieve these 2 goals (of many to come?!)

Many thanks in advance...

 

[ianforest]

Yes but it is not necessary. If you can calculate the new value for purposes of updating it, you can calculate it in a query or on a form or report so there is no reason to violate second and third normal forms by storing it.

And in English?! I think when you start tinkering with Access it makes you write in a different language

Sure. create an unbound form with a continuous form subform and a single record subform (tabbed if you want but each tab should have a separate form on it for ease of use). In the click event of a column of the continuous form, requery the other subform. In the other subform, use queries that reference the first subform's key field as selection criteria. So, the where clause will look something like:

I don't get it...i'm a complete noob. Is there anyway you (or anyone) can create a very simple working sample so I can look at it???

 

[ianforest]

Hmm ok.

1. I want to store the value as it can be one of 4 things:

Contract Sent
Contract Confirmed
Complete
Cancelled

2. I didn't realise there was a question in your reply asking me why I don't want to use a continuous form? I don't even know what one is anyway, so is there any point in me asking? I don't think these forums are for beginners!!!