Search results

I have a form with a combo box and 2 text boxes. I would like to select from the combo box and enter data into the selected record via the textboxes. After I select from the combo box, I get the message "method or data member not found" on the after update code of the combo box, which is as...

The features do not have to be separate fields. You can use one field in a separate table which has a many-to-one relationship with the main table. Then on your main form put a continuous subform which is based on the features table.

I had the same problem once. You may have accidentally typed spaces in one of your form properties. If there are only spaces in one of the properties (such as AfterUpdate or OnActivate), this message may go away if you delete the spaces. Hope this helps.

The correct spelling is BukHix.

Or set the Data Entry property of the form to Yes.

Thanks Rich, it worked. :)

I tried it with the following code, to set the focus to the subform then go to the new record: Me![sfrmStatusAll].SetFocus DoCmd.GoToRecord acDataForm, "sfrmStatusAll", acNewRec but it tells me that I can't use GoToRecord because the form is not open. Isn't it open if it has the focus? I...

I have figured out how to set the focus on my subform, but it goes to the (first field on the) first line. How can I get the focus to set on the first field on the blank line so it is ready to continue adding records in the subform?

Thanks DBL, I fixed it by replacing it with an unbound combo box.

I have a combo box on a form that used to work, but suddenly does not allow a selection. If you click on the arrow, the drop-down menu appears, the options are there and you can move the mouse pointer through them and highlight them. But when you click on an option (or try to type one in the...

Thanks, Pat! That did the trick. Also, thanks Alexandre for steering me to the Switchboard Manager. It makes it much easier to create a switchboard and get it to work the right way. I had pictures on the buttons on my custom switchboard though, but I guess I can do without those. Thanks again! :D

I had a custom switchboard (i.e. just a form that I put buttons on). After reading your response I tried creating a switchboard with the Switchboard Manager. However I then tried editing the SB form in Design View. I accidentally deleted a field. Then I deleted the SB form in order to start...

Thanks Alexandre, I tried setting the form to Popup, and removed the macro on the close button which closed the form and opened the switchboard. Now it is returning to the previous form, except when I want to return to the switchboard! The switchboard should lead to the (now popup) form, by...

I have a form which I might get to from any of several other forms. How can I get it to return to the previous form when I click the close button? Now it is only returning to the main switchboard. Thanks for any ideas.

Thanks Rich, you have helped me again!

Thanks Rich, that works, but is there a way to suppress the combo box arrow? This is because the user cannot enter in the form. I have set AllowEdits, etc. to No so that the user can only view the records. Can I take off the arrow so it looks better and saves room on the form? Or is there...

I have a continuous form which is based on my main table, tblRequests. IDNbr is the primary key of tblRequests and is an Autonumber. Another field is RequestBy which is a text field which is a user id. tblUsers stores the UserID and UserName. UserID is an Autonumber. How can I autopopulate a...

Put a macro in the Open event of each of your forms. The only action in the Macro is Maximize. In the switchboard put this macro in the Current and Load events as well as the Open event.

Never mind, it did what I wanted when I deleted the exit event and set Tab Stop to No on the field I wanted to skip.

bbeeching, thanks for your response. But perhaps I was not clear. I don't want to *always* go to the other tab from the control with the exit event, only when I click on it. (Also there are several different tabs) If I just tab or enter from the control with the exit event, I *do* want to stay...