Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







OK, I'll Try Again - Autofill And Dlookup Help PLEASE


I have been struggling with Access and the dlookup / auto lookup function.

I'll include my last post with the layout of my 2 tables and what I am trying to do

Please help if you can:

table 1 - OCMembersPayment

| transaction# | member ID | Payment Date | Payment ID | Payment Amount | Chit_checkNumber | Last Name | First Name | Notes | Ticket Number |

Table 2 - Member Roster

| Unique # | Member ID | FirstName | LastName |

Ok, I have eliminated any relationship between the two tables

What I want to happen is this:

When people put data in, the first data they fill in is member# - ex 2515 and then hit tab to move to the next field

When they hit tab, I want the expression to look at the member roster and find that #. when it does, I want the first and last names to get writen to the fname and lname fields on the form.

date is automatically filled in and Payment code (accounting code) is automatically filled in - default #

currently, this is the dlookup script I am trying to use and I get compile errors:

Private Sub MemberID_AfterUpdate()
dlookup("[memberID]","member roster","[memberID]=form!ocmemberspayment.[lastName]")
End Sub

(it is currently on the the Member # field on the form).

Later, I want to be able to ADD new members as they show up to the member roster table. So if the lookup does not return a name, once the transaction is filled in and saved, it will put the name in the member roster table. First things first though

thanks for any help


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Autofill
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.

When I fill in the form with the employees name, how can I have it autofill the dept?

I am not a programmer so if specific code is required, I would need to know exactly what it is.

Your assistance is appreciated.

View Replies !   View Related
Autofill
Two questions,

1. After my relationship table is built, is it possible to have some tables automatics fill in according to what another field in the table is inputed? EX: I have a Ordertable(orderID,itemID,Itemdesc), and a Inventory table(ItemID,Itemdesc), When you select an Itemid to put in the order form, the order Description from Inventory would appear in the Itemdesc of the order form.

Is this possible? If so how?

2. In tables, is it possible to make a cell = to something? So like if I wanted to add a subtotal and a final total after tax, I could use = * .08 or something?

View Replies !   View Related
Autofill
Can I fill all cells in a column that dont contain any data with the same value?

I have a table with about 1000 records, I have a column called "brand", half of the records contain some data but the other half dont and I really the ones that dont to contain the text "none".

Any Ideas?

Thomas

View Replies !   View Related
Autofill
I have 2 tables tblcontact and tblinfo.

tblcontact
contactID-PK
Customer
Contact

tblinfo
infoID-PK
PONumber
location

I want to build a form and have a combo box autofill these fields on the form. how can i do this?

Thanks,
Tim

View Replies !   View Related
Autofill
I am trying to self teach myself and I am sure I am going about his wrong.

I have a form with a fillable text box called ProcessCode, a drop down box called CostContainerSize, and a fillable text box called disposal cost. Their are dozens of possible process codes and container sizes of 55,30,15,5,P,Y etc... I want the disposal cost box to auto fill based on Process code and disposal cost. I wrote the following in the control source IIf([ProcessCode]="LF" and [CostContainerSize]="55","$65.00") THis works to auto fill, but obviously only for that particular set of parameters. I have tried adding "or " comments to include other sizes for that particular process code with limited success. I have tried IIf([ProcessCode]="LF" and [CostContainerSize]="55"or"30","$65.00"or"$50.00") among other variations.

Any help is appreciated.

View Replies !   View Related
Autofill Help
Ok, basically I have enough Microsoft Access knowledge to be dangerous.

I'm in the military and built a database that keeps track of the members who misuse their government travel card.

What I'm trying to do is enter a SSN into my form and have it fill in their name, rank, unit, etc if they are already in the data base.

I'm pretty sure it is possible, but not sure how to do it. Any help would be much appreciated!

View Replies !   View Related
Help!! Autofill Troubles
I created a form from a table (maintbl) with a combo box. The combo box retreives information from another table (model#tbl)and autofills it in the fields below. the information that is autofilled does not automatically get entered into maintbl. Theres probably a good reason for this but i cant figure it out. Anyone?? Im not very good with code but if thats what it takes thats what it takes.

View Replies !   View Related
Autofill Fields
Hello everybody!
Im new in Access as well as in this Forum! Glad to be here :)
Im currently developping a small application in Access 2003 and here is my problem:
I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber"
Where the SupplierID is charged once the SupplierName is selected from a combobox and the OrderNumber entered from another textbox.
Note: SupplierName values are from other table: Suppliers

Any help is highly appreciated,

Thanks in Advance

View Replies !   View Related
Autofill In Subform
I have a Subform on my form. I am trying to get it to be filled in when someone does the following:
Enters number into txtNum and then clicks on the OK cmd button.

The form is based on a table called Cancel. The subform is based on a tabled called Deal
The controls on the subform are as follows:

intNum
txtName
txtContact
txtPhone
txtFax
dtmUpdated

Also, the intNum cannot be duplicated in the Deal table.
The field that links the tables, Cancel and Deal, is intNum.

Thanks for the help.

View Replies !   View Related
Autofill Query?
Hi everyone,

I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this:

API# Current Operator
---------------------------------
1 |
1 |
2 | Bob
3 | Joe
1 | Mike
3 |
2 |


I am wondering if there is a way to run an update query which would automatically fill in the blank fields in column 2. The numbers in column 1 will always correspond to the same person in column 2.

Thanks,
Chris

View Replies !   View Related
Autofill Fields
Hi

Need some help with a table, or possible more to do with a form design..

I'm looking to autofill in a field depending on data that's in the previous field.

E.G. I have too fields.. One for employee and one for department.. I want the department field to automatically select the department whenever the employee is selected from the drop down list.

It's probably a simple query or something I need to do..

can anyone help..

Thanks
Saifon

View Replies !   View Related
Autofill Dept
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.

When I fill in the form with the employees name, how can I have it autofill the dept?

Your assistance is appreciated.

View Replies !   View Related
Validation Autofill ?
Hello !

I am having some headache trying to figure out how to autofill or validate some fields in a form. (pardon my english)

This is what i want to do:

I have a form with these fields

combobox named "status" (contains 3 values)
textbox named "date"

What i want to do in the form is to automatically set the status to a value when date is filled.

If someone could help me with this i would appreciate it alot.

:confused:

View Replies !   View Related
AutoFill Data
Hello, I am creating a helpdesk support database. My question is for my Customer Form.
As I tested the form I realized that one of my Combo Boxes may not work cause the name may not be the same when the customer calls. Let me Explain:

The Combo Box is query from one table with 5 Fields:

CompanyID > PK
Company NumberID > unique Number
Company Name > Short Name
Company Number > telephone Number
Company category > Category Company belongs to

So, when the customer calls they may give another name for the company or just an abreviation.

what I did I created a pop up form which displays all records showing the NumberID; Name; Number; and Category, with a lookup txtbox to search for the customer by typing the company NumberID on a continues form.

Now,
Here the agent can actually do two things: One, the agent Can Update the company Phone Number and Category.
the second thing will be to either double click or select the right company and autofill the combo box or should I used a textbox instead of the combo box in my form.

P.S. Right now I using a Combo Box.

Thank you. Any help in the right direction will be great.

Mr. Dix

View Replies !   View Related
Autofill Subform
Can anyone please help:confused: . I am setting up a database for events for local companies, I have an events table (event title, date, time etc) and a company table (name, address, postcode, tel, etc) They have a one to many relationship, with the events table being 1 and the company table being many.

I have a main form with the event details and I want to add a subform for companys, but would like this form to autofill the companies address and contact details when I enter the company name. Is there a way you can do this? :)

View Replies !   View Related
Autofill Text Box
Sorry me again,

I have a combo box for rooms: single, twin, double, suite, grand suite

This is found from a lookup table

In the next field on the lookup table is the cost per night for the room, how can i get the cost per night to automatically appear in a text box when the type of room is selected?

Thanks

View Replies !   View Related
Autofill Form
Hello

I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.

Well I created a Form and what I want to do is this:

If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).

Can you please give me ideas on how to do this? Thanks a lot. :)

View Replies !   View Related
Autofill Form
Hello

I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.

Well I created a Form and what I want to do is this:

If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).

Can you please give me ideas on how to do this? Thanks a lot. :)

View Replies !   View Related
AutoFill From A Combo Box
Hi there everyone. Please could someone help me with a problem! I have a form running from two qry's deceided by grp selection, written in the back end with VB. My problem arises when I attempt to autofill txt fields with the record connected to the selection made in the cbo box. Can anyone give me advice (all of which will be greatly appreciated) and can anyone see a good way of doing this. Thank you for taking the time to read this and I look forward to any guidance. Chris.

View Replies !   View Related
Autofill On Checkbox
I've searched the forums and Google. I've possibly come close to finding a solution, but can't quite get it right.

I have a checkbox that I want, when it's checked, to put the current date in a Date Completed field.

I know I have to edit the OnClick event, but the code has puzzled me.

Thanks for your help.

View Replies !   View Related
Desperate Autofill Help
Ok here goes

I need some help with getting my form(form 2) to autofill from another form(form 1).

Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse.

Basically when a customer phones up to get prices they tell me there account code( this is in the customer details table) and i enter it into a text box on form 1 and after pressing enter it opens up form 2(this bit i can do) but i cant get it to open the form and display the correct details from the table on the form.

p.s why is it access books tell you everything except what you want to know.

thanks.

View Replies !   View Related
Autofill Combo Box
I have 2 forms with 1 combo box in each form. I would like to be able to choose, for ex. a date in 1st combo box and be able to have that displayed in the 2nd form in the 2nd combo box.

View Replies !   View Related
Autofill Via A Combo Box
Hi sorry I am only new to this, I am trying to learn as I go so please excuse my ignorance. (I have done some searching on this forum but am just getting more confused)
Anyway
I have a form which is based on a table that holds all the info for orders placed by customers.
It holds info on all the orders plus some info about the customer

Example of Orders Table

Order ID
Customer No
Suburb
State
Item Number
Qty Ordered
Description
Length
Weight
Order Type
Day Received
Last Dispatch Day
Actual Dispatch Date
Comments
Date Due at Customer

On this form I would like a combo box which is linked to a Customer table which has all the details regarding the customers. When I pick the customer I would like all the other fields relating to the customer on this form (Customer No, State, Suburb) to be auto populated to save entering data individually.

Example of my Customer Table

CustomerID
Customer Name
Customer No (not unique)
State
Suburb
Customer Factory
Rail Terminal code
Destination Rail code
Destination Road code
Cust Code

I have tried many different ways but no success.

Any help or advise would be most appreciated
Tks

View Replies !   View Related
Autofill In A Subform
I manage a self-made database of property deeds for my business. Since it often happens that there are multiple owners and multiple buyers of these properties, and that many of the owners and buyers are the same people from time to time, I think I can manage this database more efficiently by using subforms that autofill when I start to type a person's name. I hope this is possible.

My main table and form are based on the deed description. Each deed will have unique buyers and sellers and each buyer and seller can be on many deeds. Thus far I have created tables and queries for sellers and buyers. The seller subform is set up and can accept entries in the form view. When I scroll from record to record, the names seem to show up where they belong, so I'm happy with that. The problem is that when a name comes up a second (or more often) time, I end up typing the entire name in again. This sort of defeats the purpose of having related tables. How can I get it to recognize that the name is already there and perform an autofill for me? What am I missing?

View Replies !   View Related
Autofill Problem
Hello friends,

I have exhausted my resources, and have not figured out how to get my text boxes to automatically fill with data associated with the selection of a combo box.

I have a table with the following fields:
PK - autonumber
Frequency - text
TimeD - text
TimeN - text

The frequency entry describes the frequency at which paramaters are to be measured, and Time1/Time2 are the times that are set by each frequency for Day and Night resp.

I know this has been discussed ad nauseam, but I have spent almost a week searching this forum as well as a couple of others, and just keep coming up short.

I have uploaded a zipped db that will better illustrate where I'm at with this project. Please have a look.

thanks in advance.

View Replies !   View Related
Autofill From A Previous Value
Okay,

What I need to do is two fold. I have a table in which I track clinets coming in and using our services.

Question 1: I want to be able to have a a date field default to the date I first type in when I open the form and remain there in all
subsequent records till I change it. The data is only entered once a week and we usually have 400 client visits per week
with about 75 - 120 per day. So it kind of gets repeatitive to keep typing in the date. I am aware of the CTRL+', but the staff who use this database do not even want to do that.

Question 2: Next problem....How would I create an autocorrect function that will automatically fill in a name...i.e. I begin to type jo and it will automatically fill in the hn...but I want the values to come from previously entered data from past records, similar to the way Excel does it in spreadsheets.

Any Ideas would be greatly appreciated.

View Replies !   View Related
Autofill A Value In A Table
Hi!
My first post here!
I am quite an amateur at database programming.

I am developing a form to input data about paint samples into a database which represents a sample library.

When the user starts to input data about a new sample into the form, they first have to choose a 'base metal' from a combo box on the form. Based on this 'base metal' selected, after all other fields have been filled in, i want to generate a 'catalogue code' for that record (The 'catalogue code' is an alpha-numeric code). Both 'base metal' and 'catalogue code' values are entered in two fields in the table.

for this i want to have a command button 'Get Catalogue Code' which runs a code to compile the 'alpha-numeric' text using two different tables. I want this text to be inserted into the 'catalogue code' field in that particular record and a message box informing the user what that text is.

I can figure out the code to compile the text and the message box. What i dont know is how to insert the text into that field in the table.

I am willing to provide any more information, including my database to anybody who can help! Thanks in advance!

View Replies !   View Related
Autofill Not Happening
I am attempting to use a combobox to fill several other unbound textboxes on a form. The syntax I am using is simple,
(SAMPLE)
Private Sub Combo48_AfterUpdate()
Me.SSN1 = Me.Combo48.Column(0)
Me.Rank1 = Me.Combo48.Column(7)
End Sub

This command is based off a query I set up combining 2 main tables. The problem is it only seems to be working for column (0) and (1), anything above that and I just keep coming up blank. Is there a better way to do this or does anyone know what may be limiting the above command from displaying any column above (1)?

Thanks
Narack

View Replies !   View Related
Next Step In The Autofill
OK, the syntax below works awesomely in a form. The SSN number is pulled from the main table and dropped into a bunch of text boxes. The only text box that is bound is called [sub#] and is stored in the supervisors table, 6 sub's per supervisor and the supervisors SSN is a child of the main table (tried to keep redundant data to a minimum). Now I need to know if there is any way to perform a similar trick in either a query or report using the [sub#](SSN equal to that of a main table entry) field to call up the record from the main table or from a query to use in a report?

Example of working syntax from form...
Private Sub Combo48_AfterUpdate()
Rank1 = Combo48.Column(4)
Sub1 = Combo48.Column(0)
Last1 = Combo48.Column(1)
Rank1 = Combo48.Column(4)
First1 = Combo48.Column(2)
MI1 = Combo48.Column(3)
EPR1 = Combo48.Column(5)
Rating1 = Combo48.Column(6)
Next1 = Combo48.Column(7)
End Sub

View Replies !   View Related
Autofill Question
I have a table called and form called insurance it has the following Insurance name, address, city, state, and zip as text boxes. I have a form called patient info and on that form i have a combo box called Primary Insurance i also have a text field under neat primary insurance called insurance address.

I'm trying to display insurance name address city state and zip in the text field once i select the insurance from the combo box. i have the following code

in the after update field in the combo box

Me.txtinsuranceaddress= me.primaryinsurance(name of Combobox)

The problem i'm having is that when i select the insurance from the combo box in the text field it only displays insurance name and not the adddress city state and zip

Please help.

View Replies !   View Related
Autofill Of 1 Field
I have 2 forms (school and venue)

I have a button on the school form that opens the venue form. I want the school field that is on the venue form to auto fill with the same information that is in the school field on the school form. Any help would be awesome.


Martha

View Replies !   View Related
Autofill For Wedding Database
I am creating an access database to assist in wedding planning. Now, on the form I am creating, I want to be able to type in a zip code & the city & state auto fill. If anyone knows any tips on how to do this-- please advise. Also if anyone has any other tips for a wedding database, let me know. All ideas are welcome & appreciated.

View Replies !   View Related
How To Autofill A Zipcode From A Town Name??
Hello

I have a table with contact names and addresses - Tel no ect, i want to set it up so that when i enter a town it automatically looks up from another table what zip code it belongs to and updates the record to include the zip code and even the state ?

Is this possible ? if so how do i do it please.

Thankyou so much in advance for any help

Darkat

View Replies !   View Related
Relationship, Link, Autofill????
Part of the database that I have written prints out consignment notes for the waste management industry. The consignment note comes on two parts Part A Company details, producer details, waste details, Transport details. Part A has 150 fields and selects some information via combo boxes from other tables (legislation codes ect.)
Part B only contains wastestream information. This form has 95 fields again pulling information from other tables via combo boxes.
The two forms are nothing alike so I use two printers
The database works without any relationships or links.
The Problem:
Together the two forms allow for 11 lines of information to be stored and printed .Part A generates the consignment number and allows for 2 lines of information. To enter the remaining 9 lines of information I use a command button to ask the user to enter the consignment note number to call up the blank part B form.
I am now wanting to store more than 11 lines of information
Because of field limitations I have had to replicate the Part B form in a table of its own. When the additional form is called 3 fields are autofilled.
What I want to do is because there can be 1 line of information or 20 lines of information I need these 3 fields always to be synchronised so as the information is keyed into Part A , it autofills into the other table .
You can't get to part B without filling in Part A, but part B or the copy for the additional lines may not be needed every time but I need it to enter the data accross in the simplest possible way.

Dave

View Replies !   View Related
2007 Autofill In Datasheets?
Access 2007 apparently no longer has the autofill feature with datasheets. This was an option that I used frequently and not having slows down greatly my particular tasks.
Is there some way of activating it?

View Replies !   View Related
Autofill Fields In Form
Hi,

I have a form that has a field called scope of work which is a combo box that you have 3 options to select from.

I have set up a table called scope of work which has other fields
ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date.

The combo box works fine selecting the scope of work but I want the fields on the form to automatically fill in the other information. Say they select option 1 in the scope of work based on this option it will fill in 40hrs at $150 per hour normal rate and $180 per hour overtime rate and this will take 4 weeks to complete. Based on the start date field it will also calculate 4 weeks from now for the completion date.

I have tried everything from queries using SQL statements, joining tables one to many etc.. and for some reason I cannot seem to get it to work for me and I've spent hours searching around for a solution..

If anyone has any ideas it would be greatly greatly greatly appreciated!!

Thanks a Bunch

View Replies !   View Related
Need: To AutoFill Value From Table/Query
I'm hoping someone here can help me out with existing code or at least point me in the right direction... In one of the databases I am developing, I need to set up the ability for one field in NEW records to be autofilled with the next value from a table or query.

Details
My database includes the following objects:
tblSupervisors - supervisor information (including an indicator if they are 'active')
tblCases - case information including name of supervisor assigned to review this case
frmNewCases - allows data entry of new information to tblCases
If someone enters a new case, the Supervisor field would (in an ideal world) automatically fill in with the name of the next active supervisor from tblSupervisors.

Example
The active supervisors in tblSupervisors are Joan, Mark, Lisa, and Gary.

Case #1 is entered and the Supervisor field is automatically pre-filled as Joan.

When Case #2 is entered later, the Supervisor field shows Mark.

When Case #3 is entered later, the Supervisor field shows Lisa. However, because the person entering the case knows Lisa is on vacation, s/he can click a button and Lisa's name is replaced with Gary.

Finally (for this example), Case #4 is entered and Joan is assigned as Supervisor again.


Whew!

Okay. That's it. (I hope.) Any and all help would be GREATLY appreciated!

View Replies !   View Related
Dependant AutoFill Text Box
Right I have a form which users will fill in

There will be a date field they fill in in one text box and then next to will be "Financial Year" text box which I want to be autofilled depending on the date they enter.

For example if they enter 01/01/05 then in the FY text box it will automatically be filled wiht

FY 2004/05

As you may know the finanical year is from the start of April till the end of March..

Can anyone help with this please?

Thank you please

View Replies !   View Related
Using Customer ID To Autofill New Form
I have a table with customers details(Address Etc) but there is too many for me to use a combo or list box so i would like to use a text box.
Here lies my problem.
What i need is to be able to enter into a text box on form1 the first few letters of the customer ID no and this will open a hidden subform that will list the customers with those first few letters.
I then want to be able to select one from the list using the number keys and once i press enter it opens another form(form2) with all the customer information already inserted into the text boxes on form2.

View Replies !   View Related
Form/Subform With Autofill In Both
I am creating an ostensibly simple database, but I need help trying to get it to work. There are three tables.

1.Users UserID, Dept Code, LName, FName
2.Boxes BoxNumber, Description, Contents, and many other fields
3.CheckOut (junction table) UserID, BoxNumber, Description, DateIn, DateOut

I want to create a form that would have the User fields at the top and a subform with the checkout fields.

I need the user fields to autopopulate after filling in the UserID (primary key).

I need the box Description to autopopulate after filling in the BoxNumber (primary key). At the moment, the form thinks that I am trying to ADD new records. There are no new records (boxes) being added. I simply want to use the form to check out and check out boxes.

Any help is appreciated. Thank you in advance.

View Replies !   View Related
Autofill 2 Table Problem
I have a Form with a combo box that takes in formation from a table and auto fills it. But i cant get that autofilled info to enter into the main table.the one that the form is based off of. I tried to use an append query to move the info from one table to the other. It didnt work. does anyone know why this error pops up i cant see anything wrong...

Concrete Pumper Database Set 0 fieldsto Nulldue to a type conversionfailure, andit didnt add 3 records due to key violations, 0 records due to lock violations and 0 due to validation rule violations...


in detail what im trying to do is this. database is for remote control concrete pumpers.

I have a form based on a table. In this table i have fields such as model #, button 1 configuration-button 12 configuration date entered, date shipped etc.I created a form from the table and Instead of entering each of the 12 button configurations I would like to have that entered automatically when a model # is selected from a combo box. So i made a table with just model # and button configurations and set up a combo box on the form to match. now i need to get the button config from the button config table to be entered into the MAIN TABLE when entered into the form by combo box. oh man...i dont know if im too far gone or what...this may not make sence so please give it your best...I appreciate any input at all. I thought i could do it with an append query and a macro but now i dont think so.


thank you

View Replies !   View Related
Autofill Field With Employee
Hello all!

Ok, lets get down straight to the point.

What i want to achieve is that when i login that automaticly the name has been filled in on every form.

I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage. In that mainpage i want to create a field that automaticly filles in my name (so if somebody else log in that their name will be filled in). After that i want when i go the incident form that automaticly the employee form has been filled in. (The person that at the moment is logged in that his name automaticly been filled in) Ive tried various ways to achieve this goal but nothing worked.

Im not that very expert in Access but im trying to understand and learning pieces by pieces the Access world. So if somebody could help me because im getting desperate! Thanks in advance all! :D

Greetz.

Creegfire

View Replies !   View Related
Checkbox To Autofill Text?
Hello-
I'm new here. I think this is the right place to ask.
I'm on Win98 using Office 2000.
I have a database that I use to run a PERL script for the record store I work at.
The database spits out a text & tabs document via a query that I then run PERL on.

My database has these fields:
date added
e-mail address (Primary Key)
name
wants
destination

In my form to enter, I use keywords that correspond to catagories in my website (I sell music, records & CDs) and also exact terms for if a customer is looking for specific items.

an example would be:

20060308
tim@couch-fort.com
Tim
*clrock~~*clrockcomp~~beach boys~~bob dylan
1

The "~~" is a separater for the PERL job.

Is there a way I can put checkboxes on my form that will auto fill data that repeats often, while leaving space for some hand typed info too?

View Replies !   View Related
Autofill Input Box (non Combo)?
Anyone know if an input box can have an autocomplete like Comboboxes? So say I type the string "Blue House, Red Carpet, Green Grass" and enter it. the next time I go to enter in a value and start typing "Green Grass", the form, auto inserts it, and as I start typing "Blue House", it is also auto inserted. anyone know if this is doable?

View Replies !   View Related
Autofill From Cascading Comboboxes
Hello Again

I've searched the forum but can't quite find what I'm looking for.
I have one main table (tblFOBData) with the fields Material, MarketCode, Vendor and Cost.
I also have a form that uses the Material and MarketCode fields in cascading combo boxes and this works fine,
However,
If you select a Material and MarketCode it will only return a single record and so I would like to autofill the data from the other two fields on to the form, preferebly without using a subform is this possible

Thanks again

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved