Visual Basic :: Data Bound Grid (this Is Tricky)

Data Bound Grid Problem
I need to be able to add a new row so that i can insert the data from the database. but i am not sure as i have already tried using the for loop to increase the row number. This didnt work. Please Help.

Set rs = New ADODB.Recordset
Dim a As Integer
Dim b As Integer

SQLContact = "SELECT * FROM Contact WHERE aKey = " & lblKey.Caption & " ORDER BY Name DESC"
rs.Open SQLContact, cn

Do While Not rs.EOF = True
a = a + 1
rs.MoveNext
Loop
Set rs = Nothing
Set rs = New ADODB.Recordset
rs.Open SQLContact, cn
DBGrid.ApproxCount = a

'enters into a particular place of the grid

DBGrid.Refresh
DBGrid.ReBind
For b = 0 To a
If Not rs.EOF = True Then
DBGrid.Col = 0
DBGrid.Text = rs.Fields("First").Value
DBGrid.Col = 1
DBGrid.Text = rs.Fields("Name").Value
DBGrid.Col = 2
DBGrid.Text = rs.Fields("Telephone").Value
DBGrid.Col = 3
DBGrid.Text = rs.Fields("e-mail").Value
rs.MoveNext
End If
Next b

DataCombos Within A Data Bound Grid
Is there a way to have a DataCombo box within a column of a data bound grid? I am using VB6 with a SQL2000 database?

I would like for the user to be able to select from a list of values for certain columns of the grid.

Are there existing components that have this ability, or must it be coded?

Any help will be greatly appreciated.

Data Format To Bound Grid
I have a date field in a table that is in the format yyyymmdd and when I display it to a bound flexgrid I would like to reformat it to mm/dd/yyyy. I believe it can be done using the StdDataFormat but am having problems trying to make it work. Does anyone have an example, or a better way to do this?? Thanks in Advance!!

Licensing Problem Of Data Bound Grid
Hello All,
I have a problem with the Data Bound Grid control of Microsoft. When I
tried to place a Data Bound Grid control in a form, a message is coming
telling that the 'Licensing information is missing'. What could be the
reason for the problem. Is it possible to get the control with the licence
information from any site. If so, please direct me in the proper direction.
Please give the me the necessary information.

Thanking you in anticipation,

Sunil

J & P (O) Ltd,
Saudi Arabia.

Data Grid Bound To A SQl Server View
Hello freinds,

Most of you would have come across similar situations many times before and would have solved it in your own style and preference. let me explain the situation.

I have the

(1)ItemRefsLookup Table :

CREATE TABLE [dbo].[ItemRefsLookUp] (
    [ItemRef] [varchar] (25) NOT NULL ,
    [ItemDesc] [varchar] (50) NULL ,
    [ItemType] [varchar] (10)  NULL )
(2)ItemCostings Table :

CREATE TABLE [dbo].[ItemCostings] (
    [ItemCostingsID]  uniqueidentifier ROWGUIDCOL  NOT NULL ,    [ItemRef] [varchar] (25)  NOT NULL ,
    [SubsidiaryCode] [varchar] (3) NOT NULL ,
    [QuotedPrice] [decimal](18, 0) NULL ,
    [ProdCost] [decimal](18, 0) NULL ,
    [SellPrice] [decimal](18, 0) NULL ,
    [Commission] [decimal](18, 0) NULL ,
    [CurrencyCode] [varchar] (3)  NOT NULL )

I have a foreign key declared as

ALTER TABLE [dbo].[ItemCostings]
ADD CONSTRAINT [FK_ItemCostings_ItemRefsLookUp] FOREIGN KEY ([ItemRef]) REFERENCES [dbo].[ItemRefsLookUp]
([ItemRef]) ON DELETE CASCADE  ON UPDATE CASCADE ,
GO

Now I need to design a data entry screen for these two tables using Visual Basic 6.0.

(1) I created a View as follows:

CREATE VIEW dbo.VIEWItemRef
AS
SELECT  dbo.ItemRefsLookUp.ItemRef AS ItemRef, dbo.ItemRefsLookUp.ItemDesc, dbo.ItemRefsLookUp.ItemType, dbo.ItemCostings.QuotedPrice, dbo.ItemCostings.SellPrice, dbo.ItemCostings.Commission, dbo.ItemCostings.ProdCost, dbo.ItemCostings.SubsidiaryCode,dbo.ItemCostings.CurrencyCode, dbo.ItemCostings.ItemCostingsID FROM dbo.ItemRefsLookUp INNER JOIN  dbo.ItemCostings
ON
dbo.ItemRefsLookUp.ItemRef = dbo.ItemCostings.ItemRef

(2)Created a VB form with a DataGrid control in it with a ADODC control. The View was used as the record source for the Grid and then the ADODC was used as the source for the grid.

(3)Brilliant it does display the data properly allows me delete any rows selected and also allows me to edit the rows whichever I selected to edit.

(4)But when i try to add a new row it comes up with errors asking me to check on the status of each OLEDB.

(5)I have read in this forum that to insert using Views we have to use an Instead Of Insert Trigger.

(6) I did create a trigger in the lines what some freinds suggested as follows:

CREATE TRIGGER UTrig_INS_ItemRef ON [dbo].[ViewItemRef]
INSTEAD OF  INSERT
AS
BEGIN
Declare @SubsCode As Varchar(5)
Declare @CurrCode As Varchar(5)
SET NOCOUNT ON

-- Check for duplicate ItemRef in ItemrefsLookup table . If no duplicate, do an insert.

IF (NOT EXISTS (SELECT IR.ItemRef
      FROM ItemRefsLookup IR, inserted I
      WHERE IR.ItemRef = I.ItemRef))
   INSERT INTO ItemRefsLookup
      SELECT ItemRef , ItemDesc, Itemtype
      FROM inserted

IF (NOT EXISTS (SELECT IC.ItemRef
      FROM ItemCostings IC, inserted
      WHERE IC.ItemRef = inserted.ItemRef))
      INSERT INTO ItemCostings
      SELECT ItemCostingsID, ItemRef ,
      '100' As  SubsidiaryCode,
      QuotedPrice, ProdCost,  SellPrice, Commission  ,
      'HKD' As CurrencyCode
      FROM inserted
END

(7)This trigger works fine when I directly try to do an insert using the Query Analyser. But it still wont work via the data grid.

I am really stuck and would appreciate if someone can help please. If you have different approach to design this data entry please do advice. Its only very recently I started using Stored procedures and triggers etc. So please ber with my ignorance.

Data Bound Grid Date Format
Is it possible to set the date format for the columns of a data bound grid (DAO)?

Right now, I have short date as the default format, but it comes up with 8/28//2002...

But I want it to be 28/08/02 instead.

Can this be done without setting the regional settings? I don't want it to change whenever the system changes regions.... thanks.

Passing Information From Data Bound Grid
I am having trouble finding the function to use in a data bound grid (DAO). What I'm trying to do, is to allow the user select a record from the databound grid, and then when he clicks the "edit" button, it would pass the "name" field from the data bound grid to a text field on the editing form.

I'm sure this can be done, but I couldn't find the function to do this. I have read about the selbookmarks function, but I don't understand how it can be applied here.

Please help... =(

Woobi.

Ammending Code To Show On Data Bound Grid
Normally when i open an ado code i do it as the code is below.

I would like to know how to ammend the code so it shows it in a databound grid???????????????

I know it has something to do with datasource property but cannot work out the correct place to place it and what to call it with.
I no longer want to show it in a textbox.

VB Code:
Private Sub Form_Load() Set r = GetData textbox1.text = r![InvoiceNo]End sub Public Function GetData() As ADODB.RecordsetOn Error Resume NextDim strsql As StringDim r As ADODB.RecordsetDim c As ADODB.Connection Set c = New ADODB.Connectionc.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False; Data Source=.home.mdb;"c.Open strsql = "SELECT * from Invoice"Set r = New ADODB.Recordsetr.Open strsql, c, adOpenDynamic, adLockPessimistic Set GetData = rEnd Function

Copy Text File Into Data Bound Grid In A Sorted Order?
I have a text file and i need to move its contents to DB Grid .
For Eg.
following is my test.txt

ravishah885 kent confirmed posted
ravi_sarla lamar pending
kent8541932 NCSU pending
kent8541933 ohio pending
kent86541934 northcarolina confirmed posted

for each line , I want "ravishah885" to be stored in one cell,"kent" in other ,"confirmed" in third cell and "posted" in fouth cell.
After storing all values i need to sort it in Data bound grid.

please mail me ASAP .
Thanx
ravi

Why I Cannot Find "Microsoft Data Bound Grid Control 5.0" Component?
Hi guys,

I'm using Windows XP, and I have installed VB 6.0 Enterprise Edition. But why I cannot find "Microsoft Data Bound Grid Control 5.0" component in VB? But Windows 98 can see? What can I do? PLEASE HELP!

THANKS!!

Bound Data Fields Not Bound
I am connecting to an Oracle data base via ADO. When I open my form the first time, the first record is displayed, but then, when doing a "moveNext" or "movePrev" or a "moveFirst" or a moveLast", the fields are not updated on the screen, but when I check the recordset programmatically, the record is the correct record (the next record or previous record and so on).

Now, for the crazy part: when I close this form and open it a second time all is well, the first record is displayed and as I navigate through the recordset (next, prev, first, last) the correct record is displayed on the form.

Any ideas?

Thanks,
zina

Bound Grid
Hi All

I wonder if someone can tell me how I can add an extra column to my bound grid. I have tried increasing the column setting but it will not reconise the extra column.

Can anyone please help

Thanks

Non-bound Grid
Is there a Grid or grid-like control in VB that I can use to manually fill with data ( I don't want to bind it to a data control or recordset) and also let the user edit the text directly in the cells?

I don't want to try binding it to a recordset because I want to verify and limit what the users can enter.

- Flexgrid and HFLexgrid are easy enough to fill manually but you can't edit cells directly (Is this true??)

- Datagrid and DBgrid can't be used unbound (Is this true??)

Is there something that I'm missing?

Grid Bound To A Recordset
any idea about to bind a grid to an ADO 2.7 recorset so when move between rows in the grid the recordset record pointer moves at the same time?

Thanks

rguia

Is There A Grid Control Not Bound To A Database?
I'm looking for a grid control that does not need to be linked to a database. I have a text file with a bunch of records each on a separate line.I want to be able to present this data to the user in a grid format so they can edit fields. Exactly like a spreadsheet would work. I tried using OLE with Excel but it always shows the menu at the top and I can't rename the coumns. The closest thing I've found was the ListView control, but it will not let me edit SubItems as far as I know.

Bound Grid Or Disconnected Recordset?
Hello,

I have a Grid that I displays to the user 6 columns of information. 4 of the 6 columns are derrived from one column value from the database. My question is which approach would be the best for my App to update the results captured by the grid. Because the grid has derived columns that make it easer for the user to choose the mask value for each record...I thought of two ways I could update the underlying table.

1) 2 Grids one Bound and one unbound.
I could have one grid(A) that represents the the data that I want updated and bind it to the database but keep it invisible and have it work with my other grid(B) when the user updates rows in grid(B) have code that updates rows in grid(A) as they are changed.

Grid(A) ColumnA=dbKey ColumnB=MaskInteger <this would match directly to the table>
Grid(B) ColumnA=GroupID, ColumnB=Description, ColumnC-D=Boolean <this information is collected by several table by joins to get User friendly data for the User>

2) 1 Grid and 1 disconnected Recordset
I could also use a disconnected Recordset with ADO instead of using the Bound Grid(A) use similar logic using the events in the grid(B) to update the recordset the have user commit changes when they click a apply button.

Any Ideas or comments how I could implement these or other ideas? I would enjoy any examples as well!

Thanks
Richard

Truegrid V7 Summing Two Columns On Bound Grid????? PLZ HELP!!!
Hi All,

I'm using Truegrid V7 and I am showing stock figures using a bound ado control. That bit is fine but I also want to have one of the columns as a sum of the other two. Does anyone have any ideas as I am well and truely stuck!

Thanx very much inadvance,

Jiggy!

Bound True Grid Dont Refresh After Delete
I'm having a problem with the grid not getting refreshed after
deleting a record. Even though the record is deleted from the table. I
have the following code in a Delete button event:
sql = "Delete from OrderDetails where Orderid = " &
datOrderItems.Recordset!OrderId
sql = sql & " and ProductId = '" &
datOrderItems.Recordset!ProductId & "'"
gconn.Execute sql
datOrderItems.Recordset.Requery
datOrderItems.Recordset.MoveNext
If datOrderItems.Recordset.EOF Then
datOrderItems.Recordset.MoveLast
End If
datOrderItems.Recordset.Filter = "Orderid = " &
cmbOrders.Columns.Item(0).Text
grdOrderDetails.ReBind

Why does the row that was deleted still show in the grid after the
delete. If I change the filter on the recordset, it will display the
new results, but when I come back to the old Order#, the same contents
will display, even the deleted record. If I close the form and load it
again, the record gone. What the heck is going on. Please help.
Thanks Michael

DBGrid, Bound Data, Moving Rows Does Not Update Data Proper
I am using the standard data control along with a DBgrid, I also have text boxes with some of the same data as the dbgrid.
I have the DBGrid and the recordset that populates the DBGrid
and the text boxes bound.
When I change rows in the dbgrid the data changes in the text boxes as I expected but I am also doing a "record number of number of records".
As well as some other stuff similar to the record counts.
Anyway all the text boxes update when I change rows in the DBGrid
but the other stuff does not update proper.
Strange though if I click on say the third line down on the dbgrid
everything updates but the record counter. Then if I click on say the
fifth line down the text boxes update with the correct data but the
record counter will then say record 3 of xx records. Then if I click on
say the 1st line everything updates proper except the record counter.
It will now say record 5 of xx records. Well by now you get the picture the other stuff lags behind by one row click.
I have tried

Private Sub DBgrid1_click()
data.recordset.refresh
End Sub

I also tried
Private Sub DBgrid1_click()
data.recordset.movenext
data.recordset.moveprevious
End Sub

Still doesn't work?????????
Any suggestion would be helpful.

HELP With Data Control And Data Bound List Box
Hi
I am new to Visual Basic and need some help.
I have a Data Control connected to an Access data base, the data base is
very simple with one table and six fields.
I have got text boxes etc. bound to the Data Control, this is all fine.
I have also got a Data Bound List box bound to the data control which is
great to lookup the data in a field of the data base. The only way I can
find of browsing the data is using the arrow buttons of the data control.

Can I change the Recordset of the data control by selecting the record
from the Data Bound List box. Is it possible to do this in code? or at all?

Have I approached this from the wrong direction?

To explain what I require- I need to have a list of the contence of one
field in by data base (say names). I need to select one record (click on
it) and show all the other fields for that record.

Incredibly simple though it sounds I can't find a way of doing it.
Any help much appreciated.
Thanks
Toby Treacher

Tricky Question - External Data Update (NOT Web Query)
Guys,

Some assistance from a guru would be appreciated....

I have a 3rd party xl addin (xla not COM) that retrieves financial data from the 3rd party's website. Using the add-in's menu items works perfectly to import the required data. Examining the cell contents yields a formula which is used to get the data.

HOWEVER, when I enter the function formula in a different cell (and not through the add-in's dialog boxes) and press enter, nothing happens - ie the data is not imported.

I have discovered though that after entering the formula into a cell (and pressing enter), then double-clicking the cell, the data is imported.

Does this action ring any bells with anyone ? I would like to programmatically set-up the formula's (easy) and have the data imported...

What is special about the double-click on the cell which means that the import will work ? This must have some sort of significance ? How can I programmatically induce double click in each relevant cell such that the import works ???

Thanks in advance for any advice.

Tricky One: Programmatically Import Data Into Access Via ODBC
This is a tricky one:

I want to programmatically import a number of tables into an Access Database via VB code. These tables can only be accessed via ODBC and require a username & password. How do I go about doing this?

Tricky One? MSSQL 'image' Data Into CDO.Message Attachment
How to do it?
I can add attachments to CDO.Message objects easily enough using Attachments.Add "<path and filename>", but how to read some binary data (e.g. an image or PDF stored in a database) into a CDO.Message attachment?

codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

Displaying Data In A (data Grid / Flex Grid)
hi i would like to know how to connect to a Access database and display all records in a flex grid in VB

also i would like to know how to achive the above task from a SQL dadabse using ADO.. in VB

Plz help me...

Shabbeer

Read A Data Bound Value On The Fly
hi

what i want to do is to read a value on the fly basically. i have bound a label on a form to a database that displays an ID number. now i cannot seem to read the current value of this number on the fly i have to use a button.

I am not sure when and how to get the correct number. If i use the event label1.TextChanged event it still shows the previous number, but on display (on the form) it has updated and shows the correct value.

something like this (but not exactly):

label1.databindings.add("text", dstables, "ID")

private sub label1.TextChanged (byval etc) handles label1.TextChanged

messagebox.show(label1.text)

end sub

Data Bound Combo Box
I'm trying to create a program that will populate a data bound combo box from a table in a database. I keep setting the fields to what I want them to be in the properties window, but I'm still only getting one record in the combo box. I have set the databound list controls in the components menu, and the path in my data object is correct and working fine. I just can't get the stupid thing to populate. Any ideas?

Bound Data Report
Hi all,

My disaster of the day (besides being a newb) is a data report that is bound to a data env. This part works fine.. master records.. detail records.. ect. I am trying to add data from a non related table that consists of a global "due date" etc. that I don't want to make static (would like to use the program next year) and didn't want to include in the master/detail tables since it is the same for all records. Managed to struggle my way thru this far, but stumped at the moment.

Your expertise appreciated

Howard

Data-bound Objects
Hi All... a question please.

I have built a database in Access to store Employee information. The Visual Basic form I have designed to populate / view the database records includes text boxes and a combo box.

The combo box is used to ented / display an employees pay frequency (weekly / monthly etc) and I have used the combo box's List property to 'store' legal responses.

By binding the form's objects to the database, I can add new enteries, but when I try to call-up records from the database, I get a 'text property is read only' error from the combo box.

Can someone please tell me how to get around this ?

Thanks.

Deane

Data Bound Controls
Just firing off questions hope this don't offend anyone but I am hoping one will get answered.

I have an access table its got a large number of fields on it. Say 150 for sake. Now when I try and bind those 150 fields it takes I swear like 2-3 minutes to open up the recordset with the ADO control I am using.

However I am able break the table down into 4 smaller tables. and bind the fields through code. I simply set their datasource fileds at design time and then manually bind these fields to the ADODC by a line of code Text1.Datasource=ADODC1 and it seems to work like 10 times faster. But its more upkeep. Is there a quicker way to bind these fields and hopefully get it back to being one table as its taking much longer to navigate four tables similtaneously for lookups and such.

Mr Tremor

Data Bound Controls?
Hi,

In this forum, most experts/professional developers saying try to avoid to use the data bound controls for ADO and just do the manually coding / SQL statement instead.

But I have another project that will develop on VB.net / express, so just wonder is the same concept still apply? avoid to use the data bound controls even in vb.net/express?

Thanks!

Data Bound Control
did your guys like data bound control? I personal feel it is suck when come to writing code for data manipulate like (add, edit, delete)

How you think about this?

Data Bound Controls
I have (2) dbCombo boxes on a form.
The first box is filled with choices from a database (Names of Manufacturers)

The second one is filled with detailed choices, about the subject listed in the first combobox. (Names of Manufacturers Models)

On form load it all works fine, but when I click on the First combo box, I want the choices listed in the second combo box to (movenext) to that record in the file.

Each combobox is linked via Data1 & Data2

A variable is given to the first combo box (dcbManufact.text), however. When debugging I noticed that the statement:

strManufact = dbcManufact.text

will apply a nullstring at that point in the code, because during run time, the text does not change until the app. gets to the END SUB statement.

Any Suggestions?

Code:

Code:
Option Explicit
Private Sub cmdExit_Click()
Unload frmNotes
Unload frmLogin
Unload frmLocks
Unload Me
End Sub

Private Sub cmdGo_Click()
strManufact = dbcManufact.Text
Data2.RecordSource = strManufact
cmdLock.Enabled = True
cmdNotes.Enabled = True
cmdPrint.Enabled = True
Data2.Move (strConnect)
End Sub

Private Sub cmdNotes_Click()
frmNotes.Show (vbModal)
End Sub

Private Sub dbcManufact_Change()
Data2.RecordSource = strManufact
End Sub

Private Sub Form_Load()
Me.Top = (Screen.Height - Me.Height) / 2
Me.Left = (Screen.Width - Me.Width) / 2
Data2.RecordSource = strManufact
Me.Show 'Used for debugging
cmdNotes.Enabled = False
cmdPrint.Enabled = False
cmdLock.Enabled = False
Data1.DatabaseName = App.Path & "Manufacts.mdb"
Data2.DatabaseName = App.Path & "Safes.mdb"
End Sub

'Code improved by vBulletin Tool (Save as...)

Data Bound Text Box
Hi,

In "Visual Basic 4 Application", which property of TextBox I need to useto bound it to ADODC control.

Any help will be greatly appreciated.

Tanu

Add Data To Bound Datagrid
I have a VB 6 form that is bound to an Access database with two tables. The parent table has databound controls (text boxes, combo boxes, etc.) on the form; the child table, which can have multiple records for each record in the parent table, is on the form in a databound datagrid.

I want to be able to completely copy an entry displayed on a form and create a new entry in the database with the duplicated information (just the ID code would change, which the user would have to input). Itâ€™s easy to copy the data in the parent table and repopulate its controls, but Iâ€™m stymied on the datagrid. I canâ€™t figure out a way to add data to it programmatically. There doesnâ€™t seem to be an AddNew method or anything similar to add a line to the grid. I thought about using an SQL INSERT command, such as

â€œINSERT INTO Child (DataKey) VALUES (" & sDKey & ")â€

where sDKey is the linking key that is the same in both parent and child tables, but I get the error message:

You cannot add or change a record because a related record is required in the table â€˜Parentâ€™.

I thought about using a single SQL command to enter records into both Parent and Child tables, but wasnâ€™t able to figure out a way to do that. I thought perhaps a multi-table query would work, but if thatâ€™s possible, I donâ€™t know how to design it properly. And Iâ€™m not sure how Iâ€™d use that to enter several rows into the Child table with just one in the Parent table.

Iâ€™ve looked through all the documentation I can find about how to enter data into a datagrid, and everything seems to presume the user will enter the data, rather than it being done by the program. Can anyone suggest a solution?

Data Bound Controls..
Hi,

In my VB6 aplication I need to use a data control..
This data control should be simple which will just hold two columns from a table..

user can update and delete and add the data
i was thinking of a dataGrid..But it seems there is lot of code behind
If we need to update del or add new rows..

In a dataGrid is it necessary to have Text box to hold individual values which need to be updated or deleted

What is the best way to do this.

Thanx
Pinky.

Data Bound Controls
Hi all, I am setting up a program in VB that uses data bound controls. What I need to do is use two separate tables in one database (Access) that automatically fills in the city and state once a user types in the zip code. One of the tables must contain 20 zip codes with cities and states in the same record. I believe that I have the form set up correctly, however
the problem that I am having is getting the textbox info (City and State) to move according to what zip code I choose. When I start the program, it has a zip code in the data control combo box and the city and state are automatically in the fields (which does match the zip code). However, when I choose a new zip code, the old city and state remain at the previous names and do not change with the zip code changes. Any ideas on how to fix this?

Data Bound Controls
Which data bound control is better to bound to a boolean field of database?

Hmmm Tricky Tricky (RESOLVED)
I wonder if you gusy can help with this one.

I have a listview on a form diplaysing lots of data from a database.

Now when i click a line of data in the listview and the whole line is nicely highlighted, i have another form with a listbox apear (its real small and only the size of the listbox) and this gives a few options with what to do with that record that has been selected on the listview.

It works find but i LOOSE focus on the listview form and altho its stil visible, the highlighted line fo datat in the list view is gone.

I need to keep the highlighted line of data int the listview.

Here is what i mean....

See this image the listview is highlighted on the record i wish

But when i click on the record and bring up the other little form (the red one) to give me some options for that record, its LOST the highlight.

Any ideas on how to keep that record highlihted, cos i need to work form the highlighted record from what option is shoosen form the red form.

Thanks

MSHFlexGrid 2 Things I Want To Edit Data In Grid And 2 I Want To Re Populate Grid
  Ok First I want to Edit the Data in the Grid... Note this is partially setup.

  I have it so that I can Edit each cell however, I havent the slightest idea of how to go about saving the edited row after its edited.

  Ok, I have 3 option buttons.... I want to select an option button and it re populate the grid with a new MDB file. I figure I will need to Close the current open MDB so I can repopulate the grid... but How to accomplish this is the question.

Bound Dropdown Box Not Updating Bound Text Boxes...
Hi All,

I have an Access 97 form with bound textboxes, and a dropdown combo. The user selects a value in the dropdown to populate the textboxes.

Because there could be duplicates values in the combobox (the values are people's last names), I have made the combo into a multi-column dropdown, adding a first name and a date of birth. It works well, until there are multiple occurrances of the same last name. What happens in that case is only one record displays in the textbox no matter which of the combobox's values is chosen.

For instance, I have a bunch of "Smith" values, and when any of them are selected, the data appearing in the text boxes remains on "Richard Smith"... Furthermore, I checked a few different duplicates other than Smith, and it is inconsistent as to which record is always displayed. Sometimes it's the first in the bunch, sometimes it's the last, etc...

If this helps, here is the Row Source of the dropdown:

SELECT DISTINCTROW [Hospital].[PatLName], [Hospital].[PatFName], [Hospital].[PatDOB] FROM [Hospital] GROUP BY [Hospital].[PatLName], [Hospital].[PatFName], [Hospital].[PatDOB] ORDER BY [Hospital].[PatLName], [Hospital].[PatFName], [Hospital].[PatDOB];

Anyone out there ever run into this before?

Thanks,
RichS

Data Bound Grid (this Is Tricky)

basically i want to hilight rows. I will be finding text and every row with that text in it i want to hilight . Now all i need to know is how to do it. Thanks..