Autofill without form in Access 07

[sshepard]

First off I have Googled till I'm ready to destroy my computer, second I DO NOT want to use a form, I hate them they are retarded, BASH ME I DONT CARE, I want to deal with tables or queries so I can manipulate raw data, I dont need a form to make it look pretty, they just slow me down.

Problem: I have a table "Serial Numbers" that contains two columns: 'Serial Number' for a product and each numbers 'Order Date'. I am using a combobox in another table "Consignment" referencing the 'Serial Number' column as a lookup, that was no problem. I would like it so that once a 'Serial Number' is selected, the associated 'Order Date' from the same row in the "Serial Numbers" table will appear next to the selection in a new field on the same row in the "Consignment" table, follow? I can also have this work in a query if need be, but I can't for the life of me find any info on how to do this in Access 07 help or on google and especially without using a damn form. PLEASE ANYONE HELP!!!

 

[sshepard]

well thats just retarded, forms are the dumbest thing to be forced to used to manipulate raw data, you can do damn near everything else in a table or query but an autofill!?!, wonder who the genius is who thought of that, needs to be dragged slowly across a field of mangled steel computer cases ensuring his/her suffering

 

[sshepard]

I understand what your saying, I have 3 elaborate databases setup using multiple tables and queries to view information and produce charts and spreadsheets. Big thing is I dont need presentation thats why forms suck for me, the people I deal with dont wanna see forms, they want to scan a line find the info and be done with it. Excel cant even compare to the data manipulation possible in Access via the tables and queries, I have made everything else I have ever thought of without a hitch until now. Having a simple autofil would just makes things a million times easier to work with and frankly I dont understand why its so impossible to just have the function exisit for tables too. You are literally forced into using form that isnt needed just to perform like the only task that isnt available in tables and queries, seems like the microsoft developers just being dicks because they can.

 

[sshepard]

Sorry didnt respond to that part of your post, I have no objections to it, I'm gonna give it a shot, I do appreciate the approach.

I'm new to Access, but I've been pleasently surprised at how easy it is to learn and adapt things to make them work the way I need and my co-workers want. I do just about everything in Access without even touching VBA which I know nothing about (could also be my downfall), but so far I have made everything I need work through equations and string references. Sorry it just flat out irks me that they make something so usefull available in one section but deny it in the rest of the program, and from what seems to be because of someone just not thinking enough to program it as a feature for the rest of the application. I can understand not allowing this in tables, no biggie the function of a table simply doesnt allow it, but with all I've done so far in queries, I think this would have been a great function to be able to use along with the ability to reference strings and create complex equations.

 

[sshepard]

Yes I know thats what I said.