Login failed for user - only occurs on one form in access

[Rowen]

I think this is the right part of the forum to post this and I hope someone can help.

I'm trying to create an access front end to an SQL Server backend, I've linked my tables and set forms to help view and edit the information, however on one form, and one form only I keep getting the message Login Failed for user " The user is not associated with a trusted SQL Server connection.

I can view the tables fine in access, and the continuous forms I've set up to view the data open fine, however the form I've set up that allows you to edit the data for a record most of the time has this message box poping up. I can after a few tries cancel out of this, and make edits to the records.

The way I've set the forms up is that I have a continuous form to display all the data, the user then selects the record and hits a button and another form opens with the data from the selected record ready to edit. However I have the same process set up for another table in the same database and I have had no issues when the form to edit the record is opened. So the issue seems to lie with that one particular form.

I have checked and double checked to see if the premissions for both tables are the same and as far as I can tell they are, does anyone have any ideas?

I hope that all made sense.

 

[DCrake]

It could be a bit of hidden corruption in the form itself. Try re creating the form using the bare basics to test its functionality. Do this work?

David

 

[Rowen]

Thanks DCrake, It turns out that the form wasn't corrupted, but re-doing the form did allow me to discover that one of the tables I was referencing for a combo box didn't have the right permissions on it. I've sorted that out and it's all working fine now.

I just knew it would be something small I'd manage to overlook.

 

[DCrake]

Like alot of things it's a case process and elimination. You get there in the end.