473,372 Members | 1,240 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Table rowsource lookup problem

Hi

Im having problems getting a column in one of my tables to display the
lookup values correctly.

The database is split, in the backend the rowsource for this
particular field is set to a query of another lookup table, this
correctly displays in a dropdown the values i want for that field.
However, in the front end the dropdown for this field is blank, when i
try to view the table in design mode to set the rowsource i get the
message: "this is a linked tabe with some properties that cant be
set", it then appears to allow me to change the rowsource and save the
table but the dropdown is still blank when viewed in datasheet mode.

Any ideas how i can get round this problem?
Thanks for any suggestions.
Paul

Oct 22 '07 #1
1 3706
On Oct 22, 9:51 am, "paulquinlan...@hotmail.com"
<paulquinlan...@hotmail.comwrote:
Hi

Im having problems getting a column in one of my tables to display the
lookup values correctly.

The database is split, in the backend the rowsource for this
particular field is set to a query of another lookup table, this
correctly displays in a dropdown the values i want for that field.
However, in the front end the dropdown for this field is blank, when i
try to view the table in design mode to set the rowsource i get the
message: "this is a linked tabe with some properties that cant be
set", it then appears to allow me to change the rowsource and save the
table but the dropdown is still blank when viewed in datasheet mode.

Any ideas how i can get round this problem?
Thanks for any suggestions.
Paul
Paul,

If you are using lookup fields my advice is to have a form use lookup
tables instead. I agree with most posters here that data should be
entered through forms rather than directly into tables. If you
absolutely insist on using lookup fields, try going into the table
design in the back end where the actual table resides.

James A. Fortune
CD********@FortuneJames.com

Me: What are you doing in the table? What if you accidentally delete
hundreds of rows by mistake? Are you going to say, "No problem.
We've got a backup."?

Secretary: I've been going into the table to make quick edits for nine
years now and I've never had a problem.

Me: Nine years ago the tables weren't as interconnected as they are
now. You don't realize how badly you can mess things up by editing
the tables directly. You really need to use the forms like I told you
before.

Secretary: O.K., I'll do that, but the forms are much slower than
editing the table directly so you're going to have to put an update
query behind a button on the form so that I can update a huge set of
related jobs all at once.

Me: Sigh.

Oct 22 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Vladimir | last post by:
Hello, I have a table in MS Access database. It has one field (with BYTE datatype) that has several properties set in Lookup tab of table Design View. Display Control = Combo Box. Row Source...
6
by: cyoung311 | last post by:
I'm trying to do an automatic update of one table from another through a form. Basically, when a selection is made for an item, in this case a particular workshop, I want to get the associated...
8
by: Roy Padgett | last post by:
I have a combo box where users select the customer name and can either go to the customer's info or open a list of the customer's orders. The RowSource for the combo box was a simple pass-through...
2
by: Kostas | last post by:
Just a quick question on this issue. Assume a small set of fixed values for a field. For instance Field Gender, values: Male, Female, Unknown If I create a Combo Box with the above values, I...
6
by: Senna_Rettop | last post by:
Hello, I'm new at Access and ran into a problem. I have a table with a field for customer's names. I want to make a lookup field out of the names by linking it to a table that holds all the...
11
by: Paul H | last post by:
Suppose I have a table called tblPeople and I want a field to illustrate whether each person prefers cats or dogs. I could do it one of three ways. 1. A plain text field Create a text field in...
4
by: littlevikinggirl | last post by:
I am writing an inventory database and want to change / filter the options shown by a Combo Box / Drop down list. On a single form first the user is to select a "Hardware Item" (Radio, Pod,...
4
by: TinaF | last post by:
I want to set a default value in a table called "Quotes" for a field called "Source." The "Source" field uses a lookup table called "Source" which looks like this: Sourceabbrev Sourcename...
9
klarae99
by: klarae99 | last post by:
I am new to this forum and still relatively new to Access (2003) and will try to explain my problem without alot of extra information to bog it down. I am trying to create an Inventory Database from...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.