Search results

Hi Any suggestions on how to achieve this? I currently have a form with two comboboxes. One contains a list of products that the user can select from the other contains a list of percentages (sales commission rates). What I want achieve is that when the user selects a specific product then a...

Hi Anyone have a solution for this? I have a form with a combobox on it with 9 different possible outcoms. What I want to achieve is that if the user has selected one of 3 specific outcomes then there is another field on the form that is required. If none of them has been selected then the...

Hi We have a database with one main data entry which stores records in a seperate table. There are several thousand records keyed in using this form. Therefore, alongside the entry we have a search form which allow the user to search for a specific record and display it in the main if he/she...

Perfect, thanks to both of you.

No. Only the 7 amount fields are stored.

Hi This little problem has me confused... My form has a number of text-boxes setup to input amounts (7 in total). In addition I have a combo-box which allows the user to select a percentage, ie. 1%, 2% etc. What I want to have happen is a calculated field that sums the 7 amount fields and...

Your right, I didn't read your reply closely enough. Works like a charm, thanks a bunch. Now back to lurking on this forum :)

Thank you for the reply, however, it doesn't really solve my problem. Or maybe I dont understand it? :confused: The way the database is setup, you are taken to an initial form, a navigation form basically with different options (command buttons). One of the takes you to the main case key-in...

Hi Anyone have the solution to this little problem? I have a form (Pipeline) with an on load event that automatically directs the user to a new empty record. Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub Now my problem is that I am trying to design a 'search form'...

Hi all, I just started working with access for the first time since Access 97 (or something similar) and to be blunt im a little rusty. Hoping to get some help tips and tricks. Regards Kenneth