Search results

MajP and moke123, Thanks very much for your time and effort. Both solutions work perfectly. Dave

Thanks Cronk, when I open frmEnterElectrodeDetails no records appear. I think MajP's idea of only showing options that have not yet been selected in the combo box is a very elegant way to handle this. (I just don't know how to do it!) Dave

Micron, I meant that the user can select a value from the combo box and then select another, etc. For example, if the field was for available colors for a car, the user could select yellow, then red, then black, etc. Thanks

Sample file attached (I hope). Thanks for the info on how to do that, jdraw.

I have a stripped down database but can't find how to attach anything here?

The subform has Linked Master Field = ElectrodeID. Linked Child Field = Electrode. For "SomeTable" I am using the intermediate table that links tblElectrode and tblWeldProcedures. Is this correct? Thanks

Hi MajP, The Row Source of the field in the subform is a table, tblWeldProcedures. The field name is Weld Procedure. Cronk, thanks. I tried using a combined primary key but it gave me nothing but trouble. Thanks Dave

Hi, I have a form with a subform where the user can select multiple items from the combobox in the subform. I want to make it impossible for the user to select the same value twice from the subform for any given record in the form. I tried to do this by setting up the intermediate table behind...

Hi, I want to have a form/subform where I can enter information for new students. On the main form I would be able to enter standard info such as name, address, contact details, etc. I want to be able to select and assign subjects for each student. I am thinking that all subjects would be...

Hi, I have a form where the user can select values from combo boxes to populate a Products table, tblProducts. The combo boxes get their values from individual tables for each field, for example tblManufacturer. I have it set up so that each combo box has the Limit To List property set to Yes...

Hi, I have a query based on two joined tables. There is a report based on the query. I had a parameter query set up where a user could enter a Job Number and the report would open up filtered for just that job number. I want to have a list box on a form where the user can select a job number...

Thanks very much, I found the problem. My query name was spelled wrong.

Hi, I have a listbox on a form where a value can be selected and then command button pressed to see a report filtered by the selection from the listbox. I am getting an error "Item not found in this collection" when I press the command button. This is code I got from this site years ago...

Hi, I have a form frmContacts where a person’s name and address etc can be entered. There are comboboxes for Country, State and City (in that order). I want the State and City comboboxes to be not visible until a value is selected from the Country combo. I have done this using...

Thanks very much

Hi, What is the best way to represent Country, State and City? Should there be individual tables for each of these three fields? Or should there be one table that contains all these fields? (with the values coming from an individual table for each field?) I would then want to use these...

Actually, it still doesn't work. The Combo Box is on my Form. When I enter a number, say 1, in the Default Value nothing appears in the combo box on the form unless I select a value.

Thanks so much, JHB, that was the missing bit of info I needed!

Hi, I have a Combobox called cmbLevel and want to set a default value. The default I want is “Standard” and this is a value in the table that is the source for the combo box. What would I need to put in the Expression Builder or the Default Value row of the Data tab in the Property Sheet...

Hi, I have a form where the user can select values from Comboboxes and the values are stored in a table. The problem is that while the form displays the values I want to see the table only displays the ID’s. I want to create a report from the tables so the ID’s are worse than useless. How can...