By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Missing option

100+
P: 147
I am trying to use:

Me![EmployeeID] = Me![RankDate].column(10)

but it won't let me use coulumn it has columnhidden and other choices but not coulumn what am I doing wrong?
Jan 20 '09 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi dahmb. Rankdate is presumably a combobox or listbox control - you do not say so in your question - otherwise there is no column property which would apply.

Columns are numbered from 0 - so Me![Rankdate].Column(10) is referring to the 11th column in your combo or listbox. Does this exist? If it doesn't, trying to assign the value of a non-existent column to EmployeeID will cause an error.

You can check that the combo or listbox is actually available when your code runs by setting a breakpoint in your code and inspecting the values of local variables, or by simply typing the following in the immediate window:

Expand|Select|Wrap|Line Numbers
  1. ? forms![your form name]![RankDate].Column(10)
-Stewart
Jan 20 '09 #2

DonRayner
Expert 100+
P: 489
Are you sure that the control "RankDate" is set as a list or combo box? From what you say it's acting like a text box.
Jan 20 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.