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?

 

[Jen-Jen]

Can you upload a zipped copy of he database?

Thanks, here is a copy

 

[mike60smart]

Thanks, here is a copy

Hi
Your main problem is that your tblCandidates has a PK set as a Number Data Type when it should be an Autonumber.

Your Main Form CandidateDetails is based on both the Candidates and Submissions table.


The Main Form should be based only on tblCandidates.
In your current Subform based on tblCalls you have a Lookup Combobox to obtain the related PK from tblCandidates.
If you set the relationship up correctly using an Autonumber for the Candidate records with a CandidateID FK in tblCalls, these values will autopupulate when adding records in tblCalls.


You should also have a Main Form based on tblCandidates with with 2 subforms based on tblCalls and tblSubmissions.

 

[Jen-Jen]

Hey mike60smart ! Thank you!
Firstly to say, I must have uploaded an older copy of the backup because I definitely do have the CandidateID PK Autonumbered. I make so many copies when I do stuff then I lose track of all of the backups!!

Thanks for pointing out regarding the CandidateDetails being based on both Candidates and Submissions tables.
So I've now redone the SubmissionsSubform and entered it as a new page in the CandidateDetails form and removed the existing one.
Tested a few entries and all working well! yeay!
I started this database first using the Personnel MS template and renamed things I wanted to keep, and then have been adding my own stuff as I get braver and more confident.

This was a great learning step, couldn't ever do it without the help from you guys, thanks so much!

 

[mike60smart]

Hey mike60smart ! Thank you!
Firstly to say, I must have uploaded an older copy of the backup because I definitely do have the CandidateID PK Autonumbered. I make so many copies when I do stuff then I lose track of all of the backups!!

Thanks for pointing out regarding the CandidateDetails being based on both Candidates and Submissions tables.
So I've now redone the SubmissionsSubform and entered it as a new page in the CandidateDetails form and removed the existing one.
Tested a few entries and all working well! yeay!
I started this database first using the Personnel MS template and renamed things I wanted to keep, and then have been adding my own stuff as I get braver and more confident.

This was a great learning step, couldn't ever do it without the help from you guys, thanks so much!

Hi
Sorry to say but just fixing that 1 issue would not fix all of the problems in your database.

You have spaces in names, you are using Lookup fields in tables as well as hard coded Lookup lists.

Upload your fixed database and let us point you in the right direction.

 

[Jen-Jen]

Hi
Sorry to say but just fixing that 1 issue would not fix all of the problems in your database.

You have spaces in names, you are using Lookup fields in tables as well as hard coded Lookup lists.

Upload your fixed database and let us point you in the right direction.

O wow that would be great! Thanks!
I have fixed all those name space issues since moving it to SP, but I'm not sure how to do a fresh back up if the FE and BE are linked to SharePoint. Is there a way to do a local backup unlinked to sharepoint?

 

[mike60smart]

O wow that would be great! Thanks!
I have fixed all those name space issues since moving it to SP, but I'm not sure how to do a fresh back up if the FE and BE are linked to SharePoint. Is there a way to do a local backup unlinked to sharepoint?

Not having worked with Sharepoint I have no idea.

 

[MajP]

 

[Jen-Jen]

View attachment 119560

Thank you!