Forms, Subforms and Data Entry

[mikethebass]

Good Evening, well it is here in the UK.

I'm an entertainer setting up a datatbase to keep track of venues, bookings and comments about venues.
I have the basics of Access but haven't got to grasp with codeing.

I have three tables, Venues, Bookings and Comments all related by a field called ClubID.

I have set up a query that pulls details from all three tables together and lets me show a main form of club details and two subforms of bookings and comments.

Each club has it's own "page"

Now Ideally from this club form I'd like to be able to add new bookings or comments.

I can put buttons onto the form that run the relevent macro to open a bookings or comments entry form.

The macro opens a data entry form and goes to a new record. I have, however, to enter the club name manually via a list box.
I'd like the form to come up with the venue already selected.

Example

I'm talking to a club let's call it Club 249
They say "we aren't booking anything until February"

I click on the add comment buton, The Add Comment Form opens up and , ideally Club 249 is already selected and the cursor has tabbed into the comments box.



The same situation could come up with bookings.

Suggestion and pointers would be much appreciated.

Mike Abbott

[RayMilhon]

If your showing the club information on your main form then you can link your subforms to the clubid on your main form and anytime you change the main form from one club to another you will see the data on the subforms change as well.

[orange]

I recommend you work on tables and relationships before getting too involved in queries and Forms.
There is a free data model here that may be useful to you. It is intended as a starting point - it may or may not suit your needs as it is - but it is a start.
I suggest you set up some test data and play "stump the model" -- see if you can get your test info in/out with the structures and adjust the model or the data or both as necessary, until the model supports what you want it to do.

http://www.databaseanswers.org/data_...ions/index.htm

[mikethebass]

Thanks Ray,

This is exactly what I have happening now. As I move from Club to club on the main form the bookings and comments subforms show the relevent data.

It is entering a new booking or comment without having to reselect the venue that is the issue at the moment.