andrew2022
New Member
i have a database made in access. there are approx 1000 records (more being added all the time). each record has its own individual code (starting at 10001). also i have a form what shows all the data. now the hard part: what i want is in the form, when i type the ref number (e.g 10045) i want it ti go 2 record number 10045, not change the number of the current record to 10045. any1 know how this can be done?
next thing i want is another database, but only certain fields. what i want it to do is when i type the ref number, i want it to find that record and enter the data from that record into the database, then when i go to the net line for the same to happen (for this database, i want to type certain records in and display the info for only the records i type, so i can easily print it)
thanx for any help with this. if this isint clear enough i will explain in more detail
next thing i want is another database, but only certain fields. what i want it to do is when i type the ref number, i want it to find that record and enter the data from that record into the database, then when i go to the net line for the same to happen (for this database, i want to type certain records in and display the info for only the records i type, so i can easily print it)
thanx for any help with this. if this isint clear enough i will explain in more detail