Record not showing correctly

Getafix the Druid

New member
Local time
Today, 04:22
Joined
Oct 21, 2013
Messages
3
Hi,

I am very new to this forum and also very new to Access. I will do my best to describe what I am doing and what my problem is.

I have a DB made up of 1 table and a number of fields for each record. I have several forms for entering department specific data, each completing part of the record.

I have one form which displays a summary of the records available.

On this form (where data cannot be entered or edited) my latest record displays. If I then apply a filter, it disappears (as it should). If I then remove the filter the record does not re-display. Even if I shut the DB down and re-open it, the record remains hidden.

If I enter design mode and 're-assign' the correct source DB then the record displays ok - until I do something else and then it disappears again. For the life of me I can't figure out why it's doing it.

:banghead: I have just about reached this stage!
 
Apologies - the record source is a table called InstallData.

The filter was applied through macro on a button.

However, it looks like I have managed to sort it. A colleague of mine too a look and noticed that each time I applied a filter, the previous filter wasn't removed. So I had filters running over the top of other filters which just made a complete mess of things.

I've cleaned it up and it looks to be working now.

Many thanks.
 

Users who are viewing this thread

Back
Top Bottom