473,325 Members | 2,860 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,325 software developers and data experts.

not populating all of my textboxes from selection in cbobox?????

29
for some reason all of my textboxes are not getting the required data. only the name, company and email txtboxes are getting the data.

control source is NULL
record source = dbo_table
Expand|Select|Wrap|Line Numbers
  1. Private Sub cboGoToContact_AfterUpdate()
  2.        Me.txtFirstname = Me.cboGoToContact.Column(1)
  3.        Me.txtCompany = Me.cboGoToContact.Column(2)
  4.        Me.txtTitle = Me.cboGoToContact.Column(3)
  5.        Me.txtEmail = Me.cboGoToContact.Column(4)
  6.        Me.txtAddress = Me![cboGoToContact].Column(5)
  7.        Me.txtCity = Me.cboGoToContact.Column(6)
  8.        Me.txtZip = Me.cboGoToContact.Column(7)
  9.        Me.txtPhone = Me.cboGoToContact.Column(8)
  10.        Me.txtFax = Me.cboGoToContact.Column(10)
  11.        Me.txtCell = Me.cboGoToContact.Column(11)
  12.        Me.txtState = Me.cboGoToContact.Column(12)
  13.        Me.txtNotes = Me.cboGoToContact.Column(13)
  14.        Me.txtwebpage = Me.cboGoToContact.Column(14)
  15.        Me.txtCountry = Me.cboGoToContact.Column(15)
  16.        Me.Refresh
  17.  
  18. End Sub
  19.  
I doubled checked all my textboxes names and they match up. Can anybody tell me what they think it could be? I am using an SQL server as my backend database.
Oct 12 '07 #1
3 1542
nico5038
3,080 Expert 2GB
Guess you know that the Column() property is "zero based" and thus entry 1 fro the recordsource is entry Column(0).

Personally I wouldn't use this, but add a (single) subform to the mainform and link that to the unique ID of the combobox. Thus the "filling" is done by Access and no code is needed.

Nic;o)
Oct 12 '07 #2
cluce
29
Guess you know that the Column() property is "zero based" and thus entry 1 fro the recordsource is entry Column(0).

Personally I wouldn't use this, but add a (single) subform to the mainform and link that to the unique ID of the combobox. Thus the "filling" is done by Access and no code is needed.

Nic;o)
yeah, my column(0) is CONTRACTID which I dont want to display. I will give the subform a try.

at first I really thought access applications was neat because of the reports and templates MS has but nothing seems to work right for me. If I can figure out how to print reports with vb.net I probably would use that for my applications if my boss lets me. Do you know of any good websites on access vba?
Oct 12 '07 #3
nico5038
3,080 Expert 2GB
yeah, my column(0) is CONTRACTID which I dont want to display. I will give the subform a try.

at first I really thought access applications was neat because of the reports and templates MS has but nothing seems to work right for me. If I can figure out how to print reports with vb.net I probably would use that for my applications if my boss lets me. Do you know of any good websites on access vba?
I know the feeling :-)
The Access reports are however great, but you'll need to understand the working of the grouplevels (The [= looking button) as they control the levels and sorting.

One good Access site is: www.mvps.org/access

Nic;o)
Oct 12 '07 #4

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

Similar topics

7
by: Drew | last post by:
I have a db table like the following, UID, int auto-increment RegNo Person Relation YearsKnown Now here is some sample data from this table,
0
by: B | last post by:
Using Access2000, the sample code below is what I have been modifying and working on since the past week and I could not get it to work properly. What I wanted to accomplish: 1) read from a...
0
by: Rich | last post by:
I've got a tabcontrol with a number of databound textboxes on a tabpage (Form1). I've got a button that the user clicks that opens a dialog (Form2) and does a lookup from a database. The user...
3
by: luna | last post by:
theres no errors in my code - but it does nothing at all - its supposed to be populating text boxes!! any ideas ? (im am pretty new to all this) If Not Page.IsPostBack Then Dim search As...
6
by: Chris Leuty | last post by:
I am populating a multiselect Listbox from a dataset, with the content of the listbox filled by one table, and the selections determined from another table. So far, I have been keeping the dataset...
3
by: RFS666 | last post by:
Hello together, I tried to find out about populating an asp.net server control (a dropdownlist) from the clientside jscript, but I didn't find a solution up to now. I cannot use a html...
0
by: Paul Hadfield | last post by:
I'm looking for thoughts on the "correct" design for this problem (DotNet 2.0 - in winforms, but that's not so important). I've got two combo boxes (combo1 and combo2), both are populating via...
2
by: Dave | last post by:
I have 3 tables of information feeding into 4 combo boxes on my main form (DR Form). I have as many list boxes (acting as text boxes) as there are fields in each one of the 3 tables. Once...
14
by: Philth | last post by:
Hi there, I've essentially got a form with several drop down, each populated by columns in various tables. The populating bit works fine - the column rows appear as they should in the menu. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.