multiple combo boxes on same form

[freddienet]

I need a form that has multiple categories, 7, listed one after another vertically. I also need the categories divided in to 2 columns.
I need to have 2 combo boxes, 1 each controlling the info for each column.
Can I do this on 1 form. Suggestions would be appreciated.

Freddie

 

[Mile-O]

I need a form that has multiple categories, 7, listed one after another vertically.

Sounds like you have some sort of spreadsheet thinking and are trying to transfer that to a form. It's highly likely that your design needs a complete revamp to be considered normalised and to work the way a relational database is expected to work.

 

[freddienet]

Thanks

Database works fine. I would like to display information on the form that utilizes 2 different tables, related, each with the same fields, each table is almost identical but the fields are lableled last year in 1 and this year in the other. Each table key is the id used to related to each table. For instance accounting courses, accounting 101, info in each table for 101, but the fields names are last year, this year.
I need the combo boxes to select different course number and display the info on 1 form for each catgegory.

Freddie

 

[Mile-O]

Database works fine.

Then, based on your next line I have to ask why you don't use a database as it should be used then?

You only need one table rather than one per year - although you do need more tables for other stuff. And relying on a year field is incorrect. You probably have a date field with the date in there - this is what you would use to determine the year. In a query.

You should not bind tables to forms. Use queries.

But reading the rest - it's as I said. You need to normalise your data. Forms, at the moment, are the least of your worries.

 

[freddienet]

Thanks

I will try using the queries, the reason for 2 tables is that each is require because of different information in each field for the 2 different years. We use the database to view results in the related fields. The database in almost entirely memo fields with notes of class results. If I use queries to displays the info can I combine them on 1 form? I have built a form that works correctly for each years seperately, I just want to be able to put both forms essentially on 1 page.
Freddie

 

[Mile-O]

Okay...


To go your way then put a tab control on your form, and then add a subform to each tab. Put a query of each table as the RecordSource of each subform.

 

[freddienet]

Thanks

I'll try that.

Freddie