microsoft.public.access

Did John's answer resolve things?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jaybird" wrote in message
news:E0B2BB85-FFC8-4CC7-A83A-1E8AC29B433A@microsoft.com...
> Perhaps I can appeal to your superior knowledge of the subject matter to
> interpret what it is I'm trying to do? I've created a version of this
> form
> that creates a list of load items, but each item on the list behaves like
> its
> own record on the mainform. I figured that a better way to go might be to
> have the mainform based on a table that only has information regarding the
> load as a whole. The subform is to include the lineitems from the load.
> The
> Load Number would link them together. I figured that I should be able to
> pick the items from a combobox and have all of the items I pick be
> associated
> with that Load Number. That way, each record on the mainform would be a
> different Load Number, and with different lineitems. I'm stumbling over
> all
> kinds of basic things, here. Like, not realizing that the search box has
> to
> be unbound. To get around this, I created a hidden textbox with the index
> I
> wanted to include. Now the thing doesn't work at all. The results of my
> search don't update to the tblHTDetails table. I'm guessing that this is
> why
> the subform won't allow me to enter more than one record, even though it's
> set up as a continuous subform. THAT'S what I need it to do... select a
> list of line items and allow them to be saved to the tblHTDetails table.
> --
> Why are you asking me? I dont know what Im doing!
>
> Jaybird
>
>
> "Douglas J. Steele" wrote:
>
>> That makes sense.
>>
>> When a combo box is bound and you select another value, you're changing
>> the
>> previous value that was contained in the field to which the combo box is
>> bound.
>>
>> It's rare (if ever done) to use a bound combo box for navigation
>> purposes.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "Jaybird" wrote in message
>> news:87D4D306-01D6-4684-BDAC-05236891A26E@microsoft.com...
>> > Okay, when I make the combobox unbound, the records are selected, but
>> > not
>> > saved to the table... What the heck? Help.
>> > --
>> > Why are you asking me? I dont know what Im doing!
>> >
>> > Jaybird
>> >
>> >
>> > "Jaybird" wrote:
>> >
>> >> I've used the wizard 3 times to recreate the combobox that selects the
>> >> records in the recordset. I double checked to make sure that the
>> >> recordset
>> >> in the code is the same as the recordset in the rowsource, and also
>> >> that
>> >> the
>> >> name of the control isn't getting confused with the controlsource for
>> >> the
>> >> control. It looks good. The problem must be something more
>> >> elementary.
>> >> Could somebody please baby-walk me through this? I've really got to
>> >> have
>> >> this
>> >> finished today, if possible. (Not that this is your problem, or
>> >> anything...)
>> >> But please... Pretty please?
>> >> --
>> >> Why are you asking me? I dont know what Im doing!
>> >>
>> >> Jaybird
>> >>
>> >>
>> >>
>>
>>
>>