Add only form, help!!!

[tony7ana]

Hello All,

I am trying to create a form in Access 2007 where employees can submit requests to management. I have a table built with all the data and a form with all the required fields. The problem that I am having is I dont want any existing requests data to show up on the form. Is there a way to make a form that shows up with only the form lables and the employees can fill their request and press save to submit the request to the table. I just do not want them to be able to see any prior requests on the form if they toggle back and forth. I removed the navigation button and record selector, but when the form opens up it still shows the first record from the table.

Any help is appreciated.... Is there a way to make a form that shows up with only the form lables and the employees can fill their request and press save to submit the request to the table without showing any existing data from the table.

 

[pbaldy]

The form has a Data Entry property. OpenForm also has an argument to control the mode.

 

[Geotch]

Go to form properties, data tab and set allow edits and allow deletions to no.

 

[Geotch]

Also create a macro to open form, go to record, go to new record.

 

[bob fitz]

Try: Set the forms "Data Entry" property to Yes.

 

[tony7ana]

Thanks Guys.

I am working on another form where I want employee data to show up once I select an employee name. I already have a table built with the employee data. I want to be able to select the employee name and once their data shows up I can edit it there if I need to without having to go the table every time.

Any Ideas?? thanks again.

 

[bob fitz]

Data should not be added/edited using the tables directly so, create a form bound to the table. Create a combo box in the Header section of the form by using the wizard. Save the form. Making a selection in the combo box will take you to the selected record.

 

[tony7ana]

Thanks Bob, I created the form and created the combo box in the header section. However, when I select the employee name, the data in the detail section underneath does not change. How do I link the 2 together?

 

[bob fitz]

If you used the wizard, as I suggested, then you would have been given three choices of combo box to be created. You should have chosen the last one.

Find a record on my form based on the value I selected in my combo box.

This option would create the code required which would look something like this:

    ' Find the record that matches the control.
    Dim rs As Object
    Set rs = Me.Recordset.Clone
    rs.FindFirst "[ID] = " & Str(Nz(Me![Combo4], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Delete the combo box and use the wizard to create it again.

 

[tony7ana]

Thanks Bob, you are awesome. That worked great!!

 

[bob fitz]

Thanks Bob, you are awesome. That worked great!!

You're welcome. Glad we got it sorted.