Microsoft Access Form Design

You could start with describing your problem(s).

Are you online right?

i figured out the problem, but need help resolving the problem. I have data associated with another table, and in my query when add that table it multiples to 1 million. I need help making this data it doesn't use much memory.

When you use multiple tables or queries in a query, you must use proper joins between them otherwise you end up with a Cartesian Product which is every row of table1 multiplied (joined to) every row of table2.  So if table1 has 100 rows and table 2 has 50 rows, your resultset would contain 50 * 100 or 5,000 rows and that seems to be what you are experiencing.

Is there a column or set of columns that will allow you to join the two tables so that the resultset would make sense.

I would prefer if someone remotely connects to my computer.

you can try to engage with an Expert via the Live service.

https://www.experts-exchange.com/live/?headerLink=contribute_realTime

Yes, I am live, but in the UTC+01:00 timezone.

You could list your query. Pat and others have vast experience in SQL.

I thought "Live" was dead.  

Joseph, if you post a database with the two tables and a query, we can help you fix the join if it is fixable.

I mainly need examples based off my information,

The page is getting its source from a query not tables. The first page I have cascading and requery setup. Where you select option one from a combo box 1 and filters the option in combo box 2. Then displays more results in a list box. The list box is important, because you select the available option it needs to remember that option for the rest of the entire 9 form (pages).

Page 2
Has a 1 combo box to make selection based off the information that you selected in the listbox.

The textbox will be used to filter data The text box suppose work for example, say there data population of 15 to 80.
if someone enters 20 is 20 >= 15? T or 20 <= 80? T
If someone enters 100 is 100 >= 15? T or is 100 <= 80? F

Then it will show all the data in those ranges.

Then there are check mark box to filter the data based on whether the particular species is yes/no option. If left unchecked it will show all related data in that particular field. If check then it will filter that species with yes. There is a about 7 yes/no option to choose from.

These filter criteria on page 2 will appear on page three in a list box.

For example pages the listbox on page 3
Name, Origin, Rate, and Population needs to filter based on the information selected from Page 1 and 2.


I just need a general example on how to write the code into vba based on the Information I provided.

i figured out the problem, but need help resolving the problem. I have data associated with another table, and in my query when add that table it multiples to 1 million. I need help making this data it doesn't use much memory.

If this is your problem, you will need to start by posting the SQL and the table definitions.  The easiest way for us to figure this out is for you to post a database with the tables involved in the query and the query itself.