I am trying to develop a "computer allocation to employee" system

I have a database table name = Asset ( all the field name are defined as text)
Table name = Asset

Cubical_No ( desc- something like seat number)
Name ( name of the employee)
Email_ID ( mail id of emoloyee)
Extension ( phone number or extension of employee)
Asset_ID ( computer name )
IP_Address1 ( ip address of computer )
IP_Address1 ( ip address of computer - if two computer are kept at same work station)

and I have a Form which will display the one record from database on screen while pressing NEXT or PREVIOUS button

 I am Trying to do following

1. Query the first record from table name = Asset
2. Show it on the form , Detail for Form given below
FORM NAME = Form1
FIELDS
    cubetxt
    nametxt
    mailtxt
    assetidtxt
    extensiontxt
    ip1txt
    ip2txt

And i wrote query given below

Private Sub Next_Click()
    Dim NextSQL As String
    DoCmd.SetWarnings False

    NextSQL = "SELECT [Asset].[Cubical_No]" & _
                   " FROM [Asset] " & _
                   "WHERE (([Asset].[Cubical_No]) > (cubetxt.Value));"

    DoCmd.RunSQL NextSQL
    MsgBox "Record query"
    DoCmd.SetWarnings True
End Sub

I know this is wrong but can anybody help me doing the two things as mentioned above , i dont want to go for cmdGetRecordset and open a saved query , i need to write a qery in form only

Pramod Chandra

This table structure needs to be normalized into 3 tables (Employee, Asset, Asset_Employee.)

The statement you wrote would return ALL records greater than the one you are currently on.

Why don't you use the button wizard and put in the next and previous record buttons? Is there a reason you only want one record at a time in your form? You will need to assign NextSQL to the Record Source of the form: Me.RecordSource = NextSQL, etc. You will need to reopen the form to do this, I think.

Can you post more info?

mmcdonal

Look it up at: http://wrox.books24x7.com