×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access throwing up an invisible form reference!

Access throwing up an invisible form reference!

Access throwing up an invisible form reference!

(OP)
I have a form that is throwing up an input box.
You select a value from a combo box then it appears.
Forms!Systems!SystemID
The form is a copy of a form which did used to relate to the Systems form. Though this forms doesn't have any relation to it. I have copied and pasted the form into another dummy db, and did a search, which couldn't find a systems reference anywhere. I've been through all the events, and can't seem to locate anything.

Does anybody have any ideas where this ghost reference could be?

Cheers,

Adam

RE: Access throwing up an invisible form reference!

Hi Adam,

just a thought, have a look in the data source for the form or combo box to see if there is still a reference to ...SystemID

HTH
 

Robert Dwyer
rdwyer@orion-online.com.au

RE: Access throwing up an invisible form reference!

(OP)
There is one reference within the form source to SystemID, but that is from a table direct, and not a form.

The values for the combo box, come from a values list. On testing, the input box comes up, when you enter data into one of the fields and move into the next text box.

This has got me stumped, as there is no afterupdate event happening!!!!


Adam

RE: Access throwing up an invisible form reference!

(OP)
Just found the cause!!!

There was a disabled combo box on the form that the record source came from a query. Which had the reference in. Why this only happened after an update, I don't know!

Cheers for the help.


Adam

RE: Access throwing up an invisible form reference!

Hi Adam,

do you mean that the data source for the form has a reference for SystemID in the data source??
ie if you goto the datasource and look at the query grid there is a reference to the other table, if so you will need to remove it access would be looking for the table to return data from it.

the other thing to look for is lookups for this field in the table itself ie if the table has a look up for a field form the table that no longer exists in the current db.

HTH

Robert Dwyer
rdwyer@orion-online.com.au

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close