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

Parameter box keeps popping up

Parameter box keeps popping up

Parameter box keeps popping up


I have 2 tables in my database: reference and billing.
I want to join these tables using refid from reference as the primary key joining refid in the billing table.
I am using the TransferSpreadsheet method to populate the billings table and an sql insert statement to populate the reference table.
I want to have primary key reference.refid as an autonumber datatype.
However, when i run a query, the join doesn't seem to work, even though there is data in both tables.
Has anyone any ideas?


RE: Parameter box keeps popping up

Your question post say a parameter box keeps popping up, what field or expression is it asking you for?

RE: Parameter box keeps popping up

the parameter box that keeps popping up asks for referenceid

RE: Parameter box keeps popping up

You must have a referenceid set as a column name or criteria in your query. From your desription it should be refid, instead. If that doesn't seem to be the problem, please post the query so we can help debug it. It will also help if you post sample data from both tables - just a few records.

Terry L. Broadbent
FAQ183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

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