Enter Parameter Value for Button that opens a form

Question

I have an access form that has one table, a few queries, and a few forms. Buttons on the main menu screen that I have created open the different forms. The one form is now prompting me to enter a parameter value for the required date which is the first column of my data sheet after the order ID which is an auto count. It did not do this before. Only after I added a field that I wanted to display which was from another field list. When I delete that off of my form the prompt goes away. I would like to display that field so I can see what category the order is - 1 or 2 but cannot seem to get around that. Another thing I noticed was that my conditional formatting no longer works when I have the order displayed on the page. The order type is a drop down that is filled out on another form if that makes a difference.

Answer 1

If the table containing the order type column is, as I'd expect, the referenced table in a relationship between the form's current table and the table of order types, then you should have a foreign key column in the current table referencing the primary key of the order types table.  You should then have a combo box control in the form, bound to the foreign key column, and listing the possible order types in its drop down list.  If the values you want to show in the combo box's list are not those of the referenced primary key column, but another non-key column, then the first column of the combo box's RowSource query would be hidden by setting the dimension of the first column to zero in the combo box's ColumnWidths property.  This can be set up manually, or you can use the combo box control wizard to add the control to the form.

Answer 2

It did not do this before. Only after I added a field that I wanted to display which was from another field list. When I delete that off of my form the prompt goes away.

this indicates that you changed the Recordsource. Can you show us what the current Recordsource is?

If you want to display the category from another table, you can use a subform. You can make a subform look like its part of the main form by removing the borders, nav bar etc.