Search results

Code Hi Bert I have recreated the buttons on the parent form and they work fine, thanks. The only issue I must now resolve is that when I move the focus to the sub form the parent disappears. Rgds Steven811

Error message Hi Bert The form is made up of one parent and 4 subforms and I want the one set of nav bars to work on which ever form I have the focus/cursor. I don't get an error message, the buttons only control the one form that they are situated on and I want to be able to use them on the...

Code Hi Bert The problem I have is that I want one set of nav buttons to work across the forms with the nested subforms. When I move the cursor to a field, I want the nav/cmd buttons to operate the records in that form. The nav buttons work, but only on the original form on which they were...

Hi I have created my own set of cmd buttons to move through records on a parent and several nested subforms. What I need to do is get them to work from where I position the cursor. I thought this was simple, here's the code I am trying to use. The red text is the bit I can't get to work...

Code Thanks, I'll have a go with that. The only thing I was expecting to see was a reference to the form/field the cursor is in at the time that I use the cmd button. Steven811

Nav bar The form, one parent and 4 subforms is littered with nav bars if I use Access's own. That is why I created my own nav bar. I have had a search aroung and I have seen mention of 'active form' but I'm unsure how to include this in my button code. Any ideas?

Still searching for set focus help I'd be really grateful for some help, I'm desperate.

Hi complete novice here I have a form that is made up of one parent form and 4 subforms. I want to use the recordset data on the screen in either Word or a report and I am not sure how to collect it as it is from several tables. The code that I have works well with one record source and I'm...

Hi I have a form made up of a parent and 4 subforms and I want to use one set of navigation buttons that work where ever the cursor is positioned, I believe this is called focus. Can anyone help. I searched through the archives and can't see anything that helps. Rgds Steve811 PS - Using 2K

Thanks I am now working on your suggestions. Steven811

Tried again I thought I had solved the problem by implementing what you had suggested, but I can't add a contact as an entry is required in tblJobTracking. I seem to be going around in a circle getting nowhere fast. New fields in tbleJobTracking have become indexed, which I half understand...

If what I am suggesting is impossible or incorrect, I'd be really grateful if someone could set me straight. Thanks Steven811

Advice please Am I barking up the wrong tree? Is it possibel to capture data from a form(s) Any views would be gratefully received. Thanks Steven811

Hi I have posted this on Forms but upon reflection I believe that it may be more appropriate here: I have a form that is made up of one main form and 4 subforms. I want to use the recordset data on the screen in Word and I am not sure how to collect it as it is from several sources. The code...

exponentially You have no idea just what a low base I started from.

Hi I have a form that is made up of one main form and 4 subforms. I want to use the recordset data on the screen in Word and I am not sure how to collect it as it is from several sources. The code that I have works well with one record source and I'm unsure how to modify it to cope with more...

Stunning Hi Dave That is truly a great help. My understanding of what happens has increased exponentially. You have no idea how much that has helped me. Thanks Steven811

Thanks I will change the relationships and try again. Steven811

Created a new table and made [Company] a primaryID Hi Dave I've converted the field to a 'no duplicates' primary key field in a new table and moved the test data over. The cbo box is the record selector on the form and uses the following SELECT statement: SELECT [tblSupplier].[SuppKey]...

Hi I attach the db I thought I'd sorted, fool that I am. I want to able to have the following relationships: One customer to many sites One site to many quotes One site to many contacts yet each contact will be unique and the problem relationship, one contact to many quotes When I set the...