Can't fill in a subform (1 Viewer)

[Jen-Jen]

Hi All
Using Front-End local with Back-End in Sharepoint.
I have a form that is split in 3 tabs, I think they are called subforms?
First is the main form, CandidateDetails, the 2nd tab is Submissions and the 3rd is CallsLog
In the CandidateDetails, there are fields for Address, phone, email etc. There is also 1 field which is ‘Supplier’, with a drop down SQL box of the names of Suppliers from tblSuppliers

Trouble is that unless you enter something in the 'Supplier' field or any field in the CallsLog subform, it won’t allow you to enter anything in the Submissions form. There are no error messages, just a ding. Had to do a process of elimination to figure it out.
When you do enter anything in the 'Supplier' field and then you’re done filling in the Submissions form, it lets you then go and delete that entry in 'Supplier' so it's not as if it's 'required'.
Neither the tblSupplier nor the tblCalls have Relationships with the tblCandidates or each other.

Please advise

 

[Mark_]

Does it work properly if you have your tables either in the local front end or a split back end? Looking to see if this is a Sharepoint issue. Alternately do you have any validation code that is looking for a "Supplier"?

 

[theDBguy]

There are no error messages, just a ding.

When you hear the "ding," take a look at the Status bar at the bottom of the Access window and see if it tells you anything.

 

[Jen-Jen]

Does it work properly if you have your tables either in the local front end or a split back end? Looking to see if this is a Sharepoint issue. Alternately do you have any validation code that is looking for a "Supplier"?

Ya SharePoint has been a pain but in this case not sure it's the cause because I went to the lists online and entered a new Candidate record in the tblCandidate without entering the Supplier and it worked. I was then able to go into the tblSubmission list and look for the Candidate in the drop down and then entered all the Submssion details.
I then did the same with the tables in the back-end file, and it was ok.
So maybe the issue is with the form.
How do I check Validation Code?
BTW there was nothing showing in the Access Status bar to accompany the ding when trying it in the form.
Thanks

 

[Jen-Jen]

Update
Maybe it's not too serious but not sure how to fix it.
Turns out that it isn't the Supplier field that is the issue but the CallsLog tab, AND I don't have to actually enter anything, I just have to click on the tab before going to the Submission subform and that works!! I'm no expert but have never come across that before!
Any thoughts please? If it's just me using it I can live with it, but this FE is going out to 4 colleagues.
Thanks

 

[mike60smart]

Update
Maybe it's not too serious but not sure how to fix it.
Turns out that it isn't the Supplier field that is the issue but the CallsLog tab, AND I don't have to actually enter anything, I just have to click on the tab before going to the Submission subform and that works!! I'm no expert but have never come across that before!
Any thoughts please? If it's just me using it I can live with it, but this FE is going out to 4 colleagues.
Thanks

Can you upload a zipped copy of he database?