Search results

1. I created a combo box that contains values queried from a table field. 2. I created another combo box that auto populates with the corresponding value of the one selected in the first combo box from the same table (just of a different field). 3. This works EXCEPT: Since some of the...

I made a query that displays values based on a combo box (unbound) on a form, but I need to figure out the following since I want to display the queried values on the form then send the query or subform to a client (not important): How can I make a subform display values from a query? OR How...

What is the code to unload a form? Thanks, Nick

Sorry to ask a new question so soon, but I really need to figure this out. . . Say I have a combo box (companyname) on a form. Then Say I have another combo box (employeename) that autofills when a particular company name is selected since there's more than one employee name for each company...

I am trying to find a way to use a text box ("Description") as a search tool in a form. For example, someone types in a value which auto-expands to what they're typing, and eventually after they finish their description, maybe it would generate a subform or table that would contain all of the...

Instead of having a user tab through all of the existing autonumbers so they can enter a new record, how can I get the autonumber field to default to no existing value (says "(AutoNumber)"). I would like a user to be able to enter a new record on first run without modifying any existing...

I am trying to prompt for a password on first run of a form. If the password is correct a certain form will load, and if not, a different form will load. I know how to prompt (stName = InputBox("Enter Password:")) and evaluate the validity of the string (or any other data type), but what...

I need to create a find command button that defaults to "Any Part of Field" and searches based on what a user has entered into various fields on a form. I would also like to eliminate the prompt that occurs with a regular find command button. Is this possible, and if so, can someone please...

I am trying to get a text box to auto-populate based on what value is selected in a combo box. Does anyone know how I could do this? Any help will be greatly appreciated, Thanks [This message has been edited by npierson (edited 05-18-2001).]

How can I get a combo box to auto populate based on the information already entered into the text box/es of a form? Thanks

I'm trying to combine a macro with two actions, but one of the actions I want to make the macro do is insert a record (when I put it on a form). Is there any way to make a macro that inserts record (after a user enters information into the form)?

I need to create a button that creates a new record and runs a macro that I created. Creating these was easy, but I haven't the slightest clue as to how to combine the two actions into one button. If this is possible, will someone please let me know how to do this? Thanks, Nick

I made a text box that displays the current date/time using =Now() in the "default value" and "before update" properties; however, it does not display on the first run of the form, it only displays after the first update if the form is kept open. I would like to display the time/date on first...