Search results

Hi When I select a value within combo box in a subform it then becomes a selection option in another part of the form. I have tried unsuccessfully to set a requery on enter option. The code I was using was as follows: An OnClick event [Forms]![MainForm]![SubForm]![SubForm]![cboBox].Requery...

Contacts table Hi Vince Thanks for your input. All of the contacts are in one table, managers have a flag field. I'm resigned to playing around with it until I can get a workable solution, the deadline will have to wait. Regards Steven811.

This is what I started with Hi Vince This was my original structure which works okay, almost. I need to be able to reflect the hierachical nature of the relationship between the contacts. For example a site contact will report to a manager, although their info is all held in the contact...

Duplicate tables Hi Vince Thanks for taking a look. I was conscious of the duplicate fields in the tables and had decided originally to include designation fields of RO or manager in the original contact and site tables. I couldn't work out how to cope with more than one manager at each RO...

Must have been me. Here it is.

Hi I have a hierachical structure of: One customer to many sites One site to many contacts One contact to many jobs. I also need to show that a contact may/or may not report to a manager at a regional office and that the RO may have several managers. I have created a structure and enclose an...

Subforms Hi Vince Subforms drive me bananas, what do you use instead? Regards Steven

Hi I have a straightforward hierachical table structure and several forms sourced from queries. The problem is only evident in the site to contact relationship, the parent customer to site relationship works fine. When I enter the test data it shows until I move to another parent record and...

All revolves around the contact The primary relationship is the one between the contact and the site, everything else is secondary. One site will have many contacts and each contact many jobs, this part of the relationship I have resolved. My problem is now that the contact may be located at...

Sketching the relationship Hi Ken Thanks for the suggestion. I have previously attempted to sketch the relationship and I enclose a screen shot that shows what I have. I need to be able to have a relationship where the RegOffice table is optional and I am unclear how to proceed. How can I...

Hi I'm building a simple CRM db for my friend and he has just moved the goal posts. The basic structure is hierachical: Customer RegionalOffice Site Contact Job The problem is that the contact may be based at the site or the RegionalOffice although sometimes there isn't a RegionalOffice...

Thanks Thanks for help.

Hi I am constructing a simple data base with 5 tables and a conventional relationship layout. I intend to use queries as the data source for various forms. My question is: Do I have an individual query as a data source for a single form and other queries for the sub forms that will be nested...

Replies I meant to say, thanks for the replies. To attempt to get around the problem I have recreated the form, with only 1 sub form nested in a parent and then nesting the parent as a sub form. Checking at each stage and seem to have got it all to work okay. Steven811

Visible forms Thanks for the replies

Hi I have a form forJT that is made up of one parent and 4 subforms. I have created the first 2 of a set of nav buttons on the parent that will operate the subforms too, where ever has focus. When I move the focus to one of the subform fields, the parent becomes invisible and I don't...

Very odd Hi Charles That was already enabled. Thanks anyway Steven811

I am creating a set of cmd buttons on a parent form for navigation around that and the 4 nested sub forms. When I move the focus to one of the sub forms and use the button the parent form becomes invisible. How do I change this so that it remains visible at all times? Here is the code for one...

OnLostFocus I've tried Private Sub Form_LostFocus() MyForm.Visible = True End Sub But it still doesn't work. I'd be really grateful for some assistance Steven811

I am creating a set of cmd buttons on a parent from for navigation around that and 4 nested subforms. When I move the focus and use the button the parent form becomes invisible. How do I change this so that it remains visible at all times? Here is the code for one of the buttons Private Sub...