Creating an action button

[qwerty]

I am a beginner at Microsoft Access.

I just have tables setup, one issue is that a field within table has number and texts. It's either a number and if no number it is N/A. Then 2 field has yes or no text. Access would not accept this input if I put integers or yes/no option. Right now all fields are showing short text. How do I fix this, without changing the data?


1. Want to be able to create 2 buttons, that display to results in a list.

2. The list will give several options to choose the location.

3. After choosing the location it will take you to new page to input values.

How do you do this?

[June7]

Not sure why you need two buttons.

Use a combobox or listbox to list locations. Code in box AfterUpdate or button Click event can apply filter or can 'go to' record on same form. For a filter approach, review http://allenbrowne.com/ser-62.html

[qwerty]

Not sure why you need two buttons.

Use a combobox or listbox to list locations. Code in box AfterUpdate or button Click event can apply filter or can 'go to' record on same form. For a filter approach, review http://allenbrowne.com/ser-62.html

Thank you for response, that article is searching for records. I am creating 2 buttons. For example western us and eastern us buttons will display a list of states in either region. You select California input some information such as client name, rainfall, elevation, and then it will display a list plants that meets the plant specifications for that area in California.

[June7]

So you want code that modifies the combobox RowSource? This is called cascading or dependent combobox - a very common topic. Usually a value is selected in a combobox that controls what is displayed in a second combobox but I suppose two buttons could do the same thing a combobox with a two-item list could do.

[qwerty]

So you want code that modifies the combobox RowSource? This is called cascading or dependent combobox - a very common topic. Usually a value is selected in a combobox that controls what is displayed in a second combobox but I suppose two buttons could do the same thing a combobox with a two-item list could do.

How do I filter the list, right now it is showing all 50 locations in the list box from the table with all 50 locations. I just want it showing specific locations.

[davegri]

Show us an image of your form so that we can better understand your requirement...

[June7]

There are many examples of code for 'cascading' combobox (or listbox). Since you want to use buttons, code in click event can be like:

Me.lboLocations.RowSource = "SELECT LocationNames FROM Locations WHERE Region = 'western';"