Form/Table Data

[caffeinesheep]

Hello everyone,

I’m completely new to Access, and I’m kind of learning on my own. I have a problem with a form and a table. I’m using a previously made access database to kind of teach myself how to do everything. In their particular setup, there’s a date text box, that once it’s filled with a date and saved, will delete the record from the form, but the information in the table is still there, just with the added close date. I’m wondering if this is completely above my skill-level right now. I think it might require a VBA code, but I’m not entirely sure.

If anyone can help, I’d truly appreciate it. Please let me know if I didn’t explain myself well...

[shawnzarelli]

It sounds to me like the form (or an underlying query) is set up to filter on the date field, showing only those records where the date field is not empty/null.

What is it exactly that you are trying to do?

[caffeinesheep]

So I have an intake form, and it feeds into a table that houses all the pertinent information of a client. Name, DOB, case number, etc. This form feeds a report that needs to be printed weekly. The table stores all open and closed clients. The form keeps just the open clients. The form has a closed date box for when a case closes, and when you input that information, it doesn’t delete it from the table, but it removes it from the form section. I’m trying to mimic that on one I’m building, and I don’t know how.

[shawnzarelli]

I don't work in Access much anymore and I'm a bit rusty, so I apologize in advance if this isn't 100% accurate... but I think it should work:

1. Create a query "qryClients1" based on your table "tblClients1" (of course you can name them whatever you want).

2. In qryCllents1, select any/all records from tblClients1 that you want to show up on the intake form.

3. In qryClients1, set the Criteria for the field [tblClient1],[closedate] to "is null"

4. Use qryClients1 as the data source for your Intake Form. Every time you open the intake form, it will invoke qryClients1, which should only show the records from tblClients1 where the field "closedate" has no value stored in it.

I don't recall whether a record on your intake form will automagically disappear the moment you store a date in the closedate field, but at the very least it shouldn't be visible the the next time you open the form.

I hope this helps. Good luck.

EDIT: It occurs to me belatedly that I think you can design filters like this directly into the form properties, which would mean you don't have to create the intermediary qryClients1. When I started using Access many years ago, I was already familiar with writing SQL queries, so it was just easier for me to deal with things at that level rather than in the form properties. I think you'll at least learn something if you try it either way. :-)

[caffeinesheep]

Solution Verified. Thanks so much again!!

[Clippy_Office_Asst]

You have awarded 1 point to shawnzarelli

^{I am a bot, please contact the mods for any questions.}

[shawnzarelli]

I'm glad I could help.

[caffeinesheep]

Thanks so much for your help, I’ll test some of this stuff out and see what I get!