Hi, I'm hoping someone can help. I created a database that will be updated by one group, and then 'selected' information viewed by another. I used forms (for the reading group) to select from dropdowns, run queries, and then display what's requested on a report. Each time the dropdown is selected, it updates the table with a record containing that selection. I tried changing the data properties to 'no' for updates, etc, but then the form doesn't display the dropdowns and buttons. How do I use a form but not let the table be updated by it? I'm not real good at coding and appreciate any help that can be given !! Thanks!!
Access Forms
- Thread starter Kath
- Start date
Thank You. You're right, I have the drop down selection with control source 'group name'. But when I remove it the records for the group name don't come back; nothing does... Nevada you're in so you're probably not even up yet. Luv Nevada !!! such great weather!!
Thank you so much for your help! I found some coding to use in 'BeforeUpdate' that cancels the update and eliminates the 'can't save' prompt:
Private Sub Form_BeforeUpdate(Cancel as Integer)
Cancel=True
End Sub
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr=2169 Then
Response = True
End If
End Sub
Private Sub Form_BeforeUpdate(Cancel as Integer)
Cancel=True
End Sub
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr=2169 Then
Response = True
End If
End Sub
Re: Update only some fields in a record
I couldn't figure out how to start a new post on this website but somehow got into one of my old posts so will ask the question here. Hopefully I can ask it in understandable language!! I'm still doing the 'oncall' database. One group needs to change the Person oncall for 'From' and 'To' Date fields, and 'From' and 'To' Time fields, but we need the cell (contact field) to change with the person change. As it is now, the lead changes the person, and the date/time fields, but the cell number remains from the previous person/record. Any ideas? I'm not an SQL writer, I just use the basic MS Access options... Much appreciated!!
I couldn't figure out how to start a new post on this website but somehow got into one of my old posts so will ask the question here. Hopefully I can ask it in understandable language!! I'm still doing the 'oncall' database. One group needs to change the Person oncall for 'From' and 'To' Date fields, and 'From' and 'To' Time fields, but we need the cell (contact field) to change with the person change. As it is now, the lead changes the person, and the date/time fields, but the cell number remains from the previous person/record. Any ideas? I'm not an SQL writer, I just use the basic MS Access options... Much appreciated!!
Similar threads
