Search results

Much apprecciated Pat, but so I can learn just how would you do it? many thanks, Lol

Okay so I've got it close, bit still a few quirks. I've got the subform to accept data and write it to the correct table but I keep getting a message asking for an entry to a table. Secondly, if a user decides to keep the first combobox on the same category but change the product it writes the...

Okay, after many hours of trawling the net and head scratching I have to ask the question: is it possible to have a form with 2 cascading comboboxes which dictate which records are shown on the subform? in addition, I wish to make entries or modifications to the records displayed in the...

This direction abandoned.

Evening Pat, to a degree you are right, something is not recording properly. I'll look at it tomorrow evening, too tired today.

Hi Pat, what can I say, it works. Perhaps I didn't explain myself properly but the recordset seemed to be a "selection" behind where it should be, and as such the subform was filtering a "move" behind. I "think" it was because my comboboxes were unbound, and what I should have done was bound my...

Hi Pat, what I discovered was that all the examples I have sen on the internet have the subform recordsource being set in the AfterUpdate event of the first combobox when in actual fact it needs to be done in the AfterUpdate event of the SECOND combobox! That and a few syntax errors now...

Hi Pat, I've just made another post which addresses other problems I suspect are overlapping this one. Thanks, Lol

having some fun and games with two cascading comboboxes on my form. basically, after selecting a value in the 1st the second is updating but what I can only describe as th underlying value is not, and hence the subform which is displaying records (in theory) based upon the combobox values is...

Hi all, for those of you who experienced my previous horrors for equipment control I've gone back to the drawing board, cut out all the inessentials and got a much simpler design going. I have on the form a couple of cascading comboboxes which filter the products to display dependant upon...

Let's mark this closed thanks I have taken a different tack.

Thanks Vlad I'll try it later.

In truth Minty I wouldn't know where to start. This project is going to be the death of me.:mad:

I'm trying to set the record source of the subform to an sql statement which filters dependant upon the value in a text box. Since the subform loads first I have set the procedure to run from the afterupdate event of the text box the sql takes the value from. Hence I am using...

Hi Minty and thanks for the reply but I'm still getting the same warning using this: Me!frm_Location.Form.RecordSource = SQL1 Me!frm_Location.Form.Requery Thanks, Lol

Okay, so I'm trying to set the record source of a subform on load event of the main form. I have tried many permutations, some that supposedly work. main form is called frmBooking, subform is called frm_Location Here is what I have and I'm still getting errors: "The expression you entered refers...

Thanks for the advice everyone much appreciated. I've been going through the tables and fields and still need to refine them slightly. I've done away with the three-way primary key in Tbl_Current_Location and changed them to indexes instead. Two things are certain: 1) I'll keep plodding on until...

Hi Pat and everyone: Yes I realise on re-examination my fields are lacking in some areas and duplicated in others so I need to look at that. Unfortunately I am having to work in the evenings due to family pressures and to be honest I am often on the brink of exhaustion and not thinking clearly...

To be honest I have probably overthought or rather over complicated the matter by harking back to what I used to know. I once did a full system in VB6 tied to an Access db using blank forms and using record sets and SQL to manipulate the display and the data. Unfortunately perhaps Access forms...

Hi Vlad, I tried that but kept getting error messages. If you have a suggestion as to how to do it I'm interested.