Brain pickin' time

[Pendragon536]

I have built a simple relational database and would like some feedback on ways to perfect function. There isn't much in the way of programming, mostly Wizard built.
The application is to track events, the people who attend those events, and vehicles associated with the events.

Table: Event (main table)
EventID; Date, Time, Narrative, Comments, etc

Attendees (related to main)
AttendeesID; LastName, FirstName, EventID, etc

Vehicles (related to main)
VehicleID; Plate, Make, EventID, etc

The tables are related, one-to-many, with the standard cascade features.

Queries:
qryEvent
Contains all the data from the Event table with the exception of the "Narrative" memo field and a "Comments " memo field - I found that the memo field truncated to 250 characters if pulled from a query.

qryAttendees
Contains all the data from the Attendees table and linked to EventID

Forms:
frmEvent
Based on qryEvent and containing the linked subforms listed

sbfrmAttendees (master / child link to frmEvent by EventID)
Embedded in frmEvent

sbfrmVehicles (master / child link to frmEvent be EventID)
Embedded in frmEvent

Reports:
rptEvent
Pulled from qryEvent and containing the linked subreports listed

sbrptAttendees (linked to rptEvent by EventID)
Pulled from qryAttendees

sbrptVehicles (linked to rptEvent by EventID)
Pulled from qryVehicles


For the most part it functions very well. I have found trouble filtering Event form from the subforms - I can't filter what event an attendee visited from the attendees name.
Also, when I export a report - either to email or to document - I get a message that the Save As function won't work on the subforms. If I by-pass this message, everything exports fine. I would like to eliminate this extraneous step.
Thanks, Dan

 

[StarGrabber]

Well explained Pendragon536, but in order to give you the right feedback I would like to have a thorough look at your application. Would it be possible for you to upload it with only a few sample records?