Am I asking for too much? See attachment (Access 97)

Topic

New Reply

Okay, there are several things I want to do and I am pretty sure it can be done. I just need the gurus to confirm it. This is the project I have been working on (and had several posts about) to allow multiusers access to only their updates. The users need to document their productive hours during the day. For the times they are working on other projects or leave early for personal time, not only do they have to adjust their “hours worked,” but also need to fill out an additional form detailing why they were not “available” during that time and what they were doing.

I want the user, when they open the form to only have access to their updates. Wendell and Charlotte, thanks for your help on this one through a previous post. I am still working on it.

As soon as the user puts a number in one of the “less” boxes, I want the appropriate subform to open. Again, showing only their records and tying the record to the one in the main form. If they are separate, I won’t know, other than by date (if they fill it out right) that the 2 records reference each other.

Am I making this too complicated? Am I asking for too much? Am I looking for Santa Claus and the Tooth Fairy?

Thanks so much!
Christine

Reply | Quote

Replies

I think you should be able to make it work correctly. Essentially what you need to do is to set the data source for the subform on the fly – you may want to do that by doing a late binding on the link to the subform. We use that approach on some applications where we want to different form to appear based on some choices on a main form. I guess I’m making an assumption that the special projects records are in a separate table, or are at least can be uniquely identified. Hope this helps.

Reply | Quote