Search results

So, is it possible to have an option group with age ranges in my form? For instance the ranges <18, 18-50, 50+.. I can get the group to pull up an individual age but have not figured out anything for an age range yet. Any help would be greatly appreciated. Thank you

OK so I have it linking to the query.. However it is pulling on the 1,2, or 3 values for age. I need it to pull the range of 1-18, 18-50, etc.. Is there a way to set that up in the option value field in my option group or not?

I thought that the option group can pull in the results from a query.. So for instance if I select <18 only those individuals pull into the query.. There has to be an if statement or something for that to happen? Correct? Same deal with the Male/Female/Both for the Gender option box.

Is there a way to filter specific data by my option group? So here is what I am doing.. I have ages of people I want split out by.. <18 18-50 50+ .. I have created my option group with those 3 values.. How can I tie this to the query I am running to filter it when I select one of those values...

Figured it out! Needed to change my form property to Data Entry: Yes.. Thank you for your help DK

right but I don't want to have to do that, is the only way to use the update query? Or is there another way maybe to be able to get this data on separate rows!

have to use two forms.. Just dont know why it saves the data only on the first line of that table.. even if i only submit data from the one form it still cancels out the data on the first row

Here is my problem! I have two seperate forms set up that I want to enter data into a single table.. This table has colums for both forms.. I have the froms linked to the table and data goes to the first line of the table but if I submit a second form it just takes the place of the original data...

Thank you so much!! Have a good one!

I agree, but if my RowSource already contains this... SELECT DISTINCT [Recoverables Main].[ID] FROM [Recoverables Main] ORDER BY [ID]; where do I throw the code Banana gave me into that?

I already have code in the rowsource that drags the data from my main table.. Can I also implement that code in there or not? Also namliam not seeing what oyu are saying with that code.. where/how do I need to insert that coding?

I have a combo box in a form that pulls up ID #'s from a main table.. When people search for a specific ID # in the form they must enter for example.. 000198 in order to pull that ID and Name from the table. Is there any code to eliminate the person having to type those 000's? So they would just...

Great idea! That will work just fine thanks a lot!!

here is a similar example to what the problem is.. Thanks again!

Try this right after the line setting the rowsource: Me.lstReloc.Selected(0) = True What do you mean the line right after the line setting rowsource? I dont understand sorry.. I have code in my row source for this list box right now..

ya i zipped my file and it is still saying invalid file

Its not letting me upload the file.. I was able to get it to work if i write the code for afterupdate in the listbox events.. but I need it in the OK button on click events.. any ideas? or ideas on how to load it to show you?

it would be either Yes or No.. That's all

Here is the rowsource of the listbox.. SELECT DISTINCT [Recoverables Main].[Relocation] FROM [Recoverables Main] ORDER BY [Relocation]; I have no events contained in the listbox.. my code in the combobox(name) is.. Private Sub cboName_AfterUpdate() On Error Resume Next...

The list box has a code stating that it will contain either a yes, or no answer from my master table depending on another combo box which is labeled associates Name.. the code I am putting into my OK button is that if the list box pops up yes then to open that form.. I see what you are saying...