Drilldown using unbound comboboxes with Access "Continuous Form" -

-

There should be a simple (R) way to do this.

I have a situation where I list the parts using continuous forms. There are things like Part Type, Manufacturer, Part Number and Quantity in Parts Listing. Examples of the list part are & amp; Quantity I can see other things from the example of the part, so displaying the existing parts is not a problem, just use a query to recover a related record or use a DLookup to pull the fields individually . 

  Type Manufacturer Number Quantity ------------------------------------ - Widgets Ekima 123ab 1 Widgets Ekma 456 1 Evil Xyz 12345 2 Lama Northwind 322-12a 1 ...

The problem is that where users need to add new parts . There are thousands of different parts, so they can not really choose from the same part number Cambodia, they want to be able to select a part type, manufacturer, and then the part number from three different combosboxes that are sequentially in each combobox Narrow results.

Choose a type of type >> select one of the creators of that manufacturer >> select the part number of that type of manufacturer >> enter the quantity

Okay, so I can do the default using two unbound combobox, with a DLookup, and link them through their row source queries. The final combobox is a fraction number with its row source filter - so it only lists the selected type and parts of the manufacturer. I have done this before such a situation and it works well.

Although I am trying to do it with continuous forms of entry and it is returning the same result for each lamp on the lamp. Example 

  Type Manufacturer Number Volume ----------------------------------- - Widgets Ekima 123ab 1 widget acme 456 1 widget acme 12345 2 widgets acme 322-12 a1 ...

Hey, what's going on? My DelPocops only seems to be using values ​​from the first record. Why?

Is this a good way to do it? Is there a better pattern for using drill-down combobox on a continuous form? The only other way I can think of this is to use the Combobox on the "Add / Edit Part" type form where the details are selected in a dialog and then the part number is left over but it seems that even here That kuldi is too much.

Continuous use of unbound controls on the form will only drive frantic, because an unbound control only references it The selected record, which can be none of them. I think the pop-up form would be great enough to add new records, and the user would be easy to understand.


Comments

Post a Comment

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

-
I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st
Read more

jquery - SimpleModal Confirm fails to submit form -

-
I am trying to confirm jQuery to show yes / no confirmation when I submit a form. I had modified (in the last list) to capture and block form submissions. However, it only works with jQuery 1.2.6, a recent upgrade stops 1.3.2, if yes is clicked, then by submitting the form. But I can not understand what is wrong / inconsistent in my code now. Demo (which works in both versions of a simple window.href implementation). $ (document) .ready (function () {$ ('input.delete'). Click (function (e) {e.preventDefault (); var target = $ (e .target); Confirm ("Really delete this event?", Function () {target.click ()});});}); How about something like this? The idea of ​​catching clicks (and fire!) On the submitted event is not click event. $ (document) .ready (function () {$ ('# myForm'). Submit (function () {var f = this; Confirm (" Remove? ", Function () {$ (f). Submit ();}) Return; Return the initial session;}}}}; Hope That this is som
Read more

php - Multiple Select with Explode: only returns the word "Array" -

-
By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a
Read more