Fields displaying when not supposed to

[Mik2045]

Hi,



I have a form where I have about 15 sets of fields (date, time, comments, etc.). So every time someone adds a record to those fields, saves and comes back in an extra blank set of fields appear. So, my concern is that whenever I go back in there are fields that are empty and visible because in one of the records I'm currently using that field.

I believe it's because of how I created the event. Currently I have it as Form_Current. I have tried:
_Open (procudes error)
_Load
_AfterUpdate
_BeforeUpdate

I really didn't want to do an AfterUpdate for each field because that's quite time consuming.

[June7]

What do you mean by '15 sets of fields'? Do you mean 15 records?

Form is in Continuous or Datasheet view? Can't use VBA code to set visibility of controls. Setting the property affects all instances of control because there is only one control for each field in the form design. The controls replicate for each record but still only one control for each field.

Can use Conditional Formating to set Enabled property of textbox.

[Mik2045]

Untitled.zip

Here is what it looks like. I think from this you can see what I mean by sets (Agent Name, Date, Time, LM, Comments).

[Missinglinq]

Your attachment won't open; it is reported to be damaged. But to be honest, images seldom help us help anyone. You really need to zip up your Access file (remove confidential data, if any) and attach it so we can really look at it.

Linq ;0)>

[Mik2045]

MikDB.zip

Okay. Here is my DB.

The form I'm having the problem with is GuestT. Thanks!

[Missinglinq]

This time your zipped file yields a file named, simply, MikDb. It has no file extension, it cannot be opened. I even tried adding an extension of mdb and accdb; Access attempts to open it then reports 'file format not recognized.'

[Mik2045]

LatestDB.zip

Okay try this one. It has an extension and I zipped it once more using Windows 7. I have 2 OSes and I used Mac to zip it last time. Most likely it should work this time. I also checked the file type and says Access database and had accdb.

[June7]

This is not a relational database structure. There is only one big flat file table. This structure will cause you problems in the future. What if you wanted to search for all the records Agent X is associated with, would have to search through about 15 fields because the agent could be in any of them.

You need a better understanding of relational database principles.

[Mik2045]

I know. I had it structured in multiple tables before but I got a bunch of errors on this form. This was the only way to solve it.

[June7]

What you need is a child table to associate agents with the primary (master or parent) record. Then use form/subform for data entry/edit.

tblAgentsAssigned
PrimaryID
AgentID
DateAssigned
etc.

This table will have as many records as needed to associate agents with primary record. Multiple records for each primary.