Search results

OOPS--kudos to both of you then.

CALL ME EL STUPIDO!!! Good call, dc -- the name was Text1 whereas the controlsource was ID... Sorry for all the bother. Thank you so much for all the help!!!

ID is the name of a control on the main form -- and it is also the name of a control on each subsequent subform -- and it is the field used in link child/master fields. On the main form, ID is the first field in the tab index. It is not essential that my command button on the subform take...

Bum-mer -- still the same object/method not supported message... Any other suggestions?

Thank you for the suggestion, dcx693. Alas, I still receive an error message - something like the object or method is not supported. Any other suggestions???

Hello, I have created two command buttons on my subform, one to set the focus back on the main form and the other to set the focus on the next subform. Here are the codes i have set up: Private Sub nextpgsub1_Click() Forms!Tabs2!R7toR9Form.SetFocus End Sub Private Sub prevpgsub1_Click()...

I am still stuck on this issue...any ideas floating out there? -E.

Not sure if this is part of your problem, but when I've received similar messages it has been because the field I am trying to leave empty is one of the link child/master fields that creates the relationship between the form and subform. Might this be your problem, too?

I have tried attaching a zipped version of my database several times this morning but have consistently been told that even my compacted and zipped database is too large. In response, I have whiddled down the db to just the bare minimums. What is attached is a rough copy of the main form...

darn! I cannot get the attachment to go through. When I first tried, I did not realise I needed to have one of a select few file types. I am trying to attach parts of an Access database, so the file type is mdb. How can I attach this? When I change the file suffix to some of those that are...

I have attached a copy of the bits of the database I am currently working on and having troubles with. The form I have posted about is labeled herein as "copy of TABS2." A colleague suggested I could remedy the cursor problem by setting "size to fit form" under the window option. I tried...

I have yet to solve this problem. Is anyone out there who can help??

I'm no expert in Access but have recently set up a database that sounds similar to yours. Have you checked to see that you have relationships created between the ID fields in the different tables? Perhaps you wouldn't need to set this up if what you're entering is based on queries. The only...

I have a main form on the first tab of a tab control and individual subforms that populate the remaining four tabs on a tab control. When I enter data into the main form, I can use the tab key to move my cursor from field to field and the part of the screen where the cursor moves to is...

I think I solved the problem I was posting about. I will put the code in here for you all to see: Private Sub Combo95_LostFocus() [Forms]![TABS2].[R13toR15Form].SetFocus End Sub (NOTE: I changed the name of the mainform from TABS-2 to TABS2 -- the dash was giving me problems in VB). My...

I have a main form (TABS-2) that resides on the first tab of a tab control. I have four subforms linked to the main form (through the link child/master fields), each residing on a separate tab of the tab control. The subforms are named R4toR6form, R7toR9form, R10toR12form, R13toR15form. I...

Sorry for not being clear--what I mean by continuous tab order is this: when someone is entering data into the form and subforms (which all reside on a shared tab control), I want them to be able to manually tab (i.e., use the tab button) to go from field to field. Therefore, when someone...

Hello, I am a very new user of Access 2000 trying to do what seem to me to be big things. Here is my current dilemma: I am working with a form and several subforms I have set up on tab controls (just using drag and drop method) and would like to have a continuous tab order that starts on the...