Recent content by coasterman

Hi. @ Vlad thank you for the example. The form behaviour is what I am looking for but I think I now see the issue I am having. my junction table is just two fields -a composite key of SolID and PcodeID. (the 'Sols' are companies who will have multiple locations) I'm wondering now whether that...

Hi. I tried the 2nd sugestion as I'd seen that suggested elsewhere but when couldnt get it to display anything but the name of the first Company all the way down the continuous form. I must have not done it right as having tried again with the correct referencing (the Text box I added to the...

Hi, I have that page bookmarked but I don't think that is my problem with this particular task. The above Function as I understand it is simply looking for the name of the form in the Forms collection rather than its name and location. This would be the reference to the control (these are...

Thanks Gasman that was exactly the problem. Trying to keep the question as simple as possible I hadn't mentioned my frmCus is actually a subform on frmMain and that is where I got into a tangle over referencing. My issue is now how the pass that extra part to the function if the Function...

I have a very simple continuous form form with two fields which are bound to the two keys in the junction table sitting between the Customer table and the Pcode tables cboCusName - Rowsource is column(0) PK from customer table and column(1) the customer name cboPcode - Rowsource is column(0)...

I haven't had chance to see how that was achieved but WoW!!! Thats brilliant and is my complete wish list for the search function and more than I had even hoped for. I cannot thank you enough. This will I am sure spur me on to get what remains of the project to completion.

Hi, It is the case as Majp has described that the full wish list would include the ability to have the combo only display those keywords which appear in the main records after the initial selcection. I was so pleased with the initial part of the puzzle being solved that I didn't want to impose...

@MajP had a look at the list box search. It wasn't really the fit for my particular situation but I have definately bookmarked it for study , excellent stuff

Hi Vlad, just seen this and exactly relates to the concept I was attempting to describe. I will take time to study the VBA, I kind of understand the logic behind it it but will definately need more study on my part but thank you so much and I wiill see it is put to good use.

I must have saved it having entered the first keyword search - apologies, the reset button on main form should revert the recordsource count back to 9 parent records

Hi , I do have cascading combo boxes on the main form already with certain users having 'not in list' privileges but the keyword bit is a much looser affair. The keywords will be looked after entirely by the users and they can add whatever they like that is meaningful to them individually...

I have a main form with a number of subforms one of which is a continuous form for adding keywords about the parent record. There is a many to many relationsip between the two tables. I then Select the parent records by an SQL Inner Join (FK of the keyword added from combo on mainfrm) and that...

Thanks DBguy - thats what I was looking for wasn't it. Entirely my fault in that I realise now what I wanted wasn't actually what I needed. When moving from the continuous form to the related record in the single form I still needed access to all records. I have found a way to drop...

Apologies if my explanation wasn't very clear - anyway hopefully the attachment will illustrate better than I was able to I did break it quite a few times stripping some tables a modules out so its about a bare as can be and still represent the issue I'm having. The two subforms are the 1st...

Hi – thanks for all the previous suggestions. Have been looking at them again now I’m had some time to re-visit this The presumption that the two views I am trying to navigate and sync between is exactly my scenario. The 2 sub forms in question are on a Tab control which is on a main form...