Recent content by CJ.B

I don’t believe the idea that all sins are equal is correct, Blade / Brian. Both stealing and murder may be breaking the law and both may be sins, but to somehow conclude that they are therefore equal simply does not follow. All prisoners in a jail may be law breakers, but that doesn’t mean...

OK, got it working, the answer was in the post already. Needed the .Text property on the text box as below: "WHERE FirstName LIKE '*" & Me.txtBoxSearch.Text & "*'" & _

This post describes exactly what I want to do. Which is to dynamically populate a list box based on each keystroke in an adjacent text box. Problem I'm having seems to be with the change event (??) I can get the list box to populate but only after typing data into the text box, changing focus...

Thanks for the feedback, especially the note about "AgreedToPrice" - I will follow up on that. And again, the idea that unbound forms are a lot of work is not lost on me, only used as I wanted the UI. Having struggled with this thought I would post a couple of links in case anyone is...

Galaxiom, You (in particular) really need to be called out (In a friendly way I hope) on the tack you are taking regarding theistic belief not being grounded in reason. One example among many is your note in Post #7 While its certainly true that not all theists consciously ground their...

Back to this after a few days. I believe I’ve resolved this issue by deleting the entire record set (for a given Order) in the Junction table and then replacing it with new data from the form for Orders that need to be edited. The original “parent record” in the Orders table is not affected and...

Thanks for the links. I'm familiar with the first 2 and particularly with Roger's work as he has some very helpful examples of subforms. Though this is my first db I've spent significant time researching and think I have a reasonable grasp of the basics - I will upload some stuff soon so can get...

My post 13 was in response to your post 11. That's as clear as I can write it out and I will upload some stuff to illustrate but will take me a day or so. No training and first db ... its very basic but junction table has led to complications ... Thanks

OK, I will post in a day or so, I want to work with this a bit first - thanks for the feed back and sorry for the delay.

Thanks for the link, I will review -- though using ADO is not going to happen! That would kill me. And thanks for warning that this is difficult - that helps. I was thinking if I add a field and tag the existing tbl_junction record set for deletion, then add the complete new order from the...

OK, I will try to make clearer, please also refer to original post. Looking for the best way to edit existing records in tbl_junction. As noted I am able to enter data to add new records from a form via VBA, like this: With rst .AddNew !Quantity = frmMain.txtQuantity .... etc ...

I hear you, its not that I'm against subforms I just think this is a situation where an unbound structure may make sense as: options are few, the UI is especially important, and the db is very basic so hopefully coding will not be too complex. Its fair to say a significant personal preference...

OK, tbl_junction only has 3 fields, the primary key is a composite of the two ID/Primary key fields shown below: tbl_junction: - ID_Orders: Number field, primary key for tbl_Orders - ID_Product: Number field, primary key tbl_Products - Quantity: Number field, records number of products chosen...

I cant seem to insert an image but Form display is very basic -- example is below. The Fruit item chosen and the quantity are stored in tbl_junction. Again, if I had more items I would gladly use combos. Fruit No. Total Apples 4 $1.50 Oranges Bananas Cherries 2 $2.00 Pears Grapes 4 $3.00 Mangos

Didn't use the subform as I really didn't like the multiple combobox UI -- for this particular application -- I think it can be great if lots of options etc. I will have about 8 options and users will usually choose about 3. I know the subform is preferred, but I really wanted the unbound UI ...