This Is Frustrating!!!

May 30, 2005

I have a form called frmFinanceProposal

on the form is a sub form called "frmFinanceProposalDialogue1"

The main form refers to my subform as "Child845"

On the subform I have a combo box that I am trying to set a filter on in the design grid of the row source


I have tried nunerous options to refer back to another combo box on the same sub form, but am getting no joy in forcing the filter

I have tried

Me!Combo57

Me.Combo57

Forms!frmFinanceProposal!Child845!Combo57

etc etc

Pls help!!!!!

View Replies


ADVERTISEMENT

Frustrating Subform

Dec 14, 2005

Hi,

I have looked through every book I have and spent hours on this but just cant get it right.

On the "menu" tab, select a customer then go to the "Calls" tab. Within the top subform is the list of telephone calls. In the below subform is the detail of the calls taken.

The problem: When I select a call, the details does not update in the form below.

Anyone willing to take a quick look? many thanks in advance.

Attached db1 (A97)

View 4 Replies View Related

Frustrating Form Glitch

Jul 28, 2006

Hi Guys,

I'm trying to create a simple form that allows me to enter information about a new customer into my database. I've normalized Addresses into another table. I've attached a stripped down example of my problem to this thread.

Everything works fine when I'm viewing exisitng records, but when I go to add a record, I enter the name and phone number of the company (native to the main form), and go to add the address informaion (native to a subform in the address form), I get a message saying I need a similar record in the Addresses table and I cannot proceed...

But I'm trying to add that record to the addresses table!!

Please guys, whats goen on??!?

View 1 Replies View Related

A Simple, Yet Frustrating Question From A Newbie

Jul 19, 2007

Hey all,

Just found the forum -- love it. I'm hoping it'll help me out with a lot of my problems. I've extensive experienced coding for PDAs, and with other databases or VBA-based programs, but I've just run into a frustratingly simple problem with an Access database I'm building for medical school (I'm a second-year med student).

Here's the situation: I've two linked tables -- e.g., TblNeuroQuestions and TblNeuroAnswers -- in which the primary key in both is the Question # field. I've created a form to easily enter data enter the questions table (question #, question, and 5 answer choices.) What I want to do is have the question text automatically be copied into the corresponding Question field in the TblNeuroAnswers table, so that I don't have to do it manually (the structure of the TblNeuroAnswers is merely Question #, Question, Answer (A,B,C,D,E), and Explanation). In other words, I want the entry of the question data in the main form (the NeuroQuestions form, which enters data in the TblNeuroQuestions table) to automatically be entered in the corresponding Question field of the TblNeuroAnwsers table.

It seems like it should be an easy thing to do; run a simple update query, for example. But I'd like the form do dual entry, so to speak. Any suggestions?

View 2 Replies View Related

Frustrating Problem With Notes Field..

Nov 13, 2006

I am trying to pull my information together for printing and also sending attachments. I have a field whose type is set to memo.

I have created 2 select queries, one pulls all of the information together except for the memo field, the other pulls the OrderID and the memo field. I then created a 3rd select query which merges those two back together (This is the only way I have been able to get this to work in the past).

Now, whenever I run the query, the notes field is trashed... All that is displayed is a few strange Chinese characters and that's it.

Someone please help with this, as it is a very big problem. Thanks!

View 2 Replies View Related

Frustrating Source Parameter Problem?

Nov 30, 2006

been trying for hours to fix a problem. my db was working but now when i open one of my forms it opens with a enter paremeter value box saying

Forms!frmServiceDateSearch.txtSearch

and then the second one saying

Forms!frmServiceDateSearch.txtSearch3

its probably something really obvious that i just cant spot.

any ideas?...they shouldnt and were not appearing.

thanks

View 1 Replies View Related

Entering Data Into Input Mask - Frustrating

Dec 2, 2006

Hi guys,

not sure which section to post this so i hope here is ok...

ive made an input mask for a postcode field. problem is its really annoying having to click the beginning of the field to enter data in the correct area of the input mask. Is there a way to automatically set the cursor to the beginning of the input mask/field when it is clicked?

thanks, James

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved