Search results

OK - this looks good and I sort of understand what is going on... Where would I put this snippet of code though? In the list box? In a button that advances to a new record? Thanks! Chris

A quick question - how would you set up a combo box so that the default value for the next record would be what was previously selected? Thanks, Chris

Hello all, I have a multiselect list box where I want to select multiple records, select a single value from a combo box in another place on the form, and then create multiple new records in a join table, like so: Table 1 Table 2 (source for List Box) (source...

Thanks!!! It works!!!! Now the real kicker... I would like to have the query that I used take the value that it will filter by from a combo box on the form, thus using a combo box instead of a button (or a series of buttons, as I originally imagined) to dictate the display in the list box. How...

It did indeed. I tried changing the RowSource rather than the ControlSource for the list box, which worked nicely, but now, when I try to select a value, it says that my list box is bound and I can't edit the control. *sigh*

Nope :( Any more guesses?

OK - the bracketing works. But it won't update the list box display.

It keeps giving me an error message that the method or data member is not found :(. Can you help?

Hello all, I would like to control the output of a list box display. I would like to have a single list box that displays values from different queries, based on a button, i.e., if a button was pressed, the list box would display the values from the query that was run by the button... any idea...

Each of the thirty tables contains a list of requirements from a different document. The one table contains a list of numbers which are assigned to systems which have those requirements associated with them. It's possible to have any given requirement to be associated with more than one system...

Hello all, I have a problem - I have about thirty or so different tables which contain data that needs to be associated with data from one other table. I don't want to have thirty different join tables. What can I do? Chris

The field from table #1 and table #2 are the same - table #1 is a source table for values that are associated with other fields containing other values in table #2. *said with an English accent* "Please sir, do you have a snippet of code you could give me?" Thanks, Chris

I have a list box that displays two fields from Table #1, and when selected, sends the value from one field (a text field) to Table #2. I would like it to send the value from a second field (a checkbox) to Table #2. How do you do this? Thanks, Chris

You can do this by making a subform in your form, based on whatever second table you want to use. You can have a subform that displays only one field.

What can I explain? Can someone else help?

Multiple-to-Multiple List Boxes OK, here goes: I have a list box from one table where I want to select one value and enter this value into multiple fields from another table, i.e. : List box: 1 2 3 4 Records from other table : Field 1 Field 2 A 1 B 1 C 1 D 2 Not all at once...

OK, here goes: I have a list box from one table where I want to select one value and enter this value into multiple fields from another table, i.e. : List box: 1 2 3 4 Records from other table : Field 1 Field 2 A 1 B 1 C 1 D...

Hello all, I'm in something of a table structure quandary. I have a database that contains a "master" table with unique system numbers and descriptions, and then another table that has requirements that are associated with these systems, and other tables that has documents associated with these...

Here's a wierd one - I have a list box in a form, displaying two fields (a number and a title). When the form is not set for data entry, it transfers both fields that are selected into a table. When the form is set for data entry, it only transfers the number data, leaving the title behind. I...

Take multiple screenshots and then paste them into Paint or some better picture editor. Save each screenshot and then cut & paste them together in Paint. Save that as a .gif file, or use another program to convert to a .jpg file, and there you are. Chris