Using my laptop as a frisby over databases

[emine]

Very simple question. I simply want to display a data field from and Access application in a text box. I have tried every command I know, and just cant seem to make it work.
I have tried:
text1=unitprice
and
unitprice.show
among other failed attempts.
Please help me before I use this laptop like a frisby.

Caren't quite work out what the problem is,

Have you tried either of these approachs

1. Binding the Access Database to the form

2. Manually opening the database and recordset.

Personally l woulod use the second approach, don't like data binding in multi-user environments.

Hope it helps....or give more details

[emine]

I had already tried that, I have the information in my application. I simply used the DB Wizzard and that works great. I had allready created the DB with Access. But now I need to pick it apart and I cant figure out how. If I can display a scecific field then I can manulate it. That is my problem.

Add a reference to your project, Project-> References-> MS DAO 2.5 3.0
General Procedure
Dim db as database
Dim rs as recordset

Form Load Procedure

set db = dbengine.opendatabase(Path & Name)
ser rs = db.openrecordset("TableName",dbopendynaset)

rs.movefirst

txtBox = rs!Fieldname

If this don't work then you have real problems. This is probably the simplest method

Hope it helps

[emine]

That did exactly what I wanted with a slight modification. Thanks, I owe you a beer sometime.