Search results

I used the code you suggested, and then tried to change to match the names. I have 3 tables with the following fields: tbl_event EventID EventName tbl_org OrgID OrgName tbl_event2org JoinID EventID OrgID I have set up the relationships, and each table has a form. The form for...

Thanks, MadeFemere. I tried your code, but I cannot make it work. Same with the link from Burrina (which I actually referred to in my OP as not working. It either throws up a #name or #error message, depending on whether I place the textbox in a form or a report.

Hi all, I hope this makes sense. I have a form with a subform in it. The Subform relates to a junction table. For each record on the main form, there may be more than one record on the subform. The Subform only has one field on it (a combobox). What I want to be able to do is have a text...

I figured out the issue. I simply hadn't noticed that because I am using a sub-form, I can click 'new record' for the subform and it adds a second association to the junction table. :banghead::banghead:

Thanks, Jdraw, and apologies for not being clear. Using the form, which is based on the Event table, I want to be able to associate more than one organisation with that event (using the junction table). So currently, I have a subform based on the junction table embedded within the form based...

Hi all, I have been using Access in a very light-touch way for years, but am trying to build a new database to replace one I made some years ago. The reason for the rebuild is to separate out my data more, rather than keeping everything in essentially one big unwieldy table. I have created a...