Form subform not allowing me to add a value mystery

[Ruegen]

I have a subform that won't allow me to enter data into a date field. If click the Access design icon and then click back to form I can suddenly make data entry.

The forms are not locked.

I can't figure this one out.



If I open the subforms query source it runs fine and I can edit data within it so I can't see it being a query problem...

[June7]

Want to provide db for analysis? Follow instructions at bottom of my post.

[Ruegen]

Want to provide db for analysis? Follow instructions at bottom of my post.

I'll have to pull away that particular section, clear it and send it to you sometime in the next few hours.

[Ruegen]

Want to provide db for analysis? Follow instructions at bottom of my post.

https://www.dropbox.com/s/qknrfjc3ivgam1o/Database.zip

you have to enter "smith" in the splash screen.

you may need to add a task in the admin form

still does problem even with all the database cut out which means if you can see what it is it will fix on the full database too.

It's the tasks panel on the right of the form after the splash screen login.

[June7]

Why do you need to repeat the telemarketer info in the subform? The filter criteria on telemarketersurname in the subform doesn't make sense because the subform synchronizes with the record on the main. The subform RecordSource needs the telemarketerID field from tblTasks table. Remove tblTelemarketer from subform RecordSource.

Change the subform AllowAdditions property to Yes.

[Ruegen]

Why do you need to repeat the telemarketer info in the subform? The filter criteria on telemarketersurname in the subform doesn't make sense because the subform synchronizes with the record on the main. The subform RecordSource needs the telemarketerID field from tblTasks table. Remove tblTelemarketer from subform RecordSource.

Change the subform AllowAdditions property to Yes.

I've opened the subform (the form) and put the form property allowadditions to yes with the same result.

I removed the filter from the query (replaced with TelemarketerId field)- works just the same (probably did that when I was fooling around with getting it to work) and I removed the table.

problem is still there on initial load. Once I click to design view and then back for some reason it works but I need to work on the first time I load.

[June7]

Problem may be related to the embedded macro and the tempVars variable. I replaced it with a VBA procedure and the form opens fine. I don't like nor use macros.

Private Sub SaveVarBtn_Click()
DoCmd.OpenForm "frmSwitchStaff", , , "TelemarketerSurname='" & Me.txtSurname & "'"
DoCmd.Close acForm, "frmSplashscreen"
End Sub

Recommend query for main form not be INNER join, use LEFT:
SELECT tblTelemarketer.TelemarketerID, tblTelemarketer.TelemarketerName, tblTelemarketer.TelemarketerSurname, tblTelemarketer.MergedNameT, tblAreas.AreasID FROM tblTelemarketer LEFT JOIN tblAreas ON tblTelemarketer.TelemarketerID = tblAreas.TelemarketerID;

Be aware the form will still open even if invalid name entered on the splash screen but since there probably aren't any records for the bad name, the form won't work.

Why is the Task textbox Locked?

[Ruegen]

Problem may be related to the embedded macro. I replaced it with a VBA procedure and the form opens fine. I don't like nor use macros.

Private Sub SaveVarBtn_Click()
DoCmd.OpenForm "frmSwitchStaff", , , "TelemarketerSurname='" & Me.txtSurname & "'"
DoCmd.Close acForm, "frmSplashscreen"
End Sub

Why is the Task textbox Locked?

Thanks I will give it a go. Just out of curiosity if you want to convert your database for online use don't macro's then become important since they convert over for web use?? Just curious as I've never had that answered and I'm worried that all this vba is going to bite back later...

Also what happened to creating the temp variable? That needs to be called for later use in the database...

Task is given by the admin not the user. That is why it is locked. It's a request by the admin to do a task. The user justs fills out the completed part only.

[Ruegen]

I had the macro on read only.. I think that is why.

[Ruegen]

...yah it was the macro. I had open form to read only. I removed that. Without you mentioning that though I would have been guessing for months.

Attachment 13461

[June7]

I've never built a web database but yes as I understand, need to use macros for the client web forms. I have seen web database with VBA but think those was for forms/reports only for local use, not served up on web for client use.