Search results

I have a field that I use on several forms, ie Mr. Mrs, Ms, Prof, Dr. Hon. Question? is it better to put these in a table and use Look Up on each form or to use a List box on each form?

Thanks Pat, not sorting this particular data just providing most common defaults but allowing Agent to add additional values. They will have some rules to follow but it's not important the Format although I do have some format rules set.

Thanks all you have been very helpful, read all the links but Pat's comment cleared up all the confusion.

I am using a table as the source, I just used States as an example but the items in the list are not states but items so the values would be unknown and not something I can pre populate. What I have in the table is just a starting point and the most common. should I use a combo box instead?

I am using the lookup wizard in a form. What I need is for the user to be able to type a value that is not in the list and have it automatically added to the lookup. example would be, I have a lookup for States, the list only has the 50 US States. The user needs to enter Alberta which is not in...

Thanks a bunch Bastanu, Doc and Gizmo, all very helpful I am getting what I need from all this great help.

I am using a Tabbed Subform, I need a popup window that I can secure, so I can put account number information into the database. What is the best way to do this? I would like the popup or tab inside the main tab. ie tab inside another tab. (hope you understand what I mean) example: I have a...

Thanks Doc Man this helps a lot.

Can you use a subform in the header? I use the rest of the form for other purposes.. for example The screenshot of the header is on a form used to setup new agents. This process might need to be interrupted however if there is an immediate need to go to the dispatch screen for example. It is...

Here is a screen shot of what I want. I use this same header on every form so no matter what is being done the user has immediate access to the areas that are needed instantly. I do not want to have to recreate this header for each page. I want to make a Template, ie save it for repeated use.

I've created a form header with added controls and features that I want on every form in my database. How can I save this as a template to use on all my forms? It seems that saving in AutoFormat is not doing the trick

Thanks Pat, you are correct I need to use buttons for my application instead of tabs. My tables have so much info I need to break in down into sections, and I will need to PW protect some of the buttons so only admin can access, update of view the information.

I have a tabbed sub form, I only want to display the tabs on my main form and when you click on a tab the sub form comes up as a popup. Then I want to be able to position the tabs in a location of my choice. Can anyone explain how to do this or steer me to a link for a tutorial on this? I am...