Showing select information

[lithium]

Oh well. I'm just gonna have to mess with it for a long time. That didn't really do anything that I need accomplished. The double clicking feature on the list box works fine (that's why I didn't need an edit button) and filled it all in properly. I only need to find a way to write out a SQL statement and VBA for once they click "Add" on the Add form (after filling in all the information) the SQL string will add a NEW record to my table with all the information from the text boxs.

[lithium]

Biggest issue was the fact that the database wouldn't allow me to make a validation rule for each field. It would error everytime I made my own error message in it.

[ItsMe]

Add it to where??? There are only two tables. The form opens with textboxes that have the values you wanted. Sorry I can not wrap my head around what it is you are trying to accomplish. If you want to update some fields, you should be able to do it from the first form. There can't be more than 6 possible fields that could be updated in the entire DB.

[lithium]

I'm trying to get the "New request" form (known in my thing under the forms as "Table1" sadly) to be able to add all those text box values into the database as a new issue. The reason I have another form for add, and another for edit is to separate the application. It allows the main form (Main1) to remain on the computer at all times, and show all Active Requests for repair. Then when someone wants to add a request, they go down to the "Add Request" button and press it and the Add form appears and they fill in all the information (Title, Assigned To, Requested By, Priority, Status, comments) and when they click "Add" it will add to the database as a new record. I originally had this working but switched it off the Macros and was going to use a SQL string to grab all the text box values they added and send it as a New Record to the Table but apparently this is worse trying to explain this.

[lithium]

I just switched it back and it's working again. I simply bound the Add form to the main table, and bound all the text fields to their proper fields (Title text box to the Title field, etc...) and had when the form loads (Add form, after user clicks the Add Request button) the On Load event just goes to a new blank record, then the user simply adds his information for the request and clicks "Add" and it loads it in. The problem has been with Validation though for me. I can't get it to require text be in each field without throwing errors and not showing a box basically saying like "You need to enter a title for this request." or somethign I can design

[lithium]

I just really want to change the Add form to being loaded with no information being put out (right now it automatically jumps to a new record and even using close event it saves the new record). I want to just load the Add form, and if the user presses Add after filling in his information, then it will send an action query to grab all the txt fields and boxes and submit them as a new record. it just seems easier.

[ItsMe]

You don't need another form to then assign values via OpenArgs to string variables; to then create an UPDATE query. You can retrieve the values from the listbox and assign them to string variables or send the values straight to a new record.

You could bind the first (main) form to an updatable query and have the listbox create a new record in the Main form. The Main form can be a Data Entry form. A control button can cancel the selection in the listbox or save the new record. That is a more conventional approach.