Search results

Basically what I'm asking is how to update field in the subform to mach current record? (it should be similar when inserting record as well should it not?)

Got it, but... I will work on this overnight. One more thing (If I don't find the answer until tommorow): How can you auto insert value in subform just by inserting it in the form? (Adding one supplier in supplier form, and comes to the point to chose from the goods that he supplies, that is...

I have, a small problem. Don't know how to set up the basic thing. TABLES I have a table "suppliers" and table “goods" Not all of the suppliers are delivering all of the goods, but all of them are delivering more then one. I want to be able to, when adding supplier to be able to select goods...

Have you tried... ...to re-create one query that is not big or complicated, I mean from ground up? It might not give explanation for your problem but it just as well, might solve it!

Addition to previous post I have to simplify this!!! I need someone to explain me how to exclude conditions that are left empty in that search form!!! Sorry...

Problem: I can't make it work to search from one single search form to search on several fields to reduce number of results. I have over 1000 of records and you can search by name and code to get specific record. You can also search by angle Alfa and Beta, Graf type (left and right), etc. If...

New issue being raised Now I still haven't made the changes that I spoke above, but there is a another issue being raised: Since this DB is for keeping records for children with hip problems, Dr. that is in charge for this project asked me about making another DB for records of hip Ultrasound...

Can you give me some more info? OK, question one: If you are trying to use this form as search form (when you enter value in PCNO form recognizes it as new record and couse it is set as no duplicates it gives you duplicate value thing) you will have to do something else. You can create a...

Three things First, Mile thanks for the input, I did corrected the Name thing, and didn’t use the apostrophes. Second, I made it!!! In search form I put (instead of textbox or cmd button) combo box that has a row source in table Angle receiving values from 35-95. In After Update on combo box...

Ok, I'm working on one project for children hospital where they are have records on children that have hip problems at birth. I have table 'Patient' and fields on which i need search are: ‘Name’ (text) ‘code’ (Number -indexed no dup.) 'Alpha angle R' 'Alpha angle L' 'Beta angle R' 'Beta angle...